(5)computeHour int @ computeMinute int @ hourOFminute int time char (5)hourOFminute=@ minute/60 @ computeMinute=@ minute% 60 @ computeHour =hour + @ hourOFminute @ time=RTRIM (CONVERT (char,computeHour)) + : + RTRIM (CONVERT (char,computeMinute)) (@ time)
- Викликаються дані функції наступним чином:
- Якщо не потрібно підсумовувати час, то функцію SUM не слід писати
- SELECT dbo.get_time (SUM (dbo.get_hour ( lt; Імя_поля_табліци gt;)), SUM (dbo.get_minute ( lt; Імя_поля_табліци gt;)))
Додаток
Головна форма
using System;System.Collections.Generic;System.ComponentModel;System.Data;System.Drawing;System.Text;System.Windows.Forms;Autotransportation
{partial class FormMain: Form
{FormMain ()
{() ;. IsMdiContainer=true;
} void driversToolStripMenuItem_Click (object sender, EventArgs e)
{OpenForm=false; (Form Child in this.MdiChildren)
{(Child is FormDrivers)
{= true;
}
} (OpenForm)
{index=0; (int x=0; x lt; this.MdiChildren.Length; x ++)
{(MdiChildren [x] .Name == FormDrivers )
{= x;
}
} (MdiChildren [index] .Visible == true)
{. MdiChildren [index] .Activate ();
}
{. MdiChildren [index] .WindowState=FormWindowState.Normal; .MdiChildren [index] .Visible=true;
}
}
{FormDrives=new FormDrivers () ;. MdiParent=this; _AddToolStrip () ;. Show ();
}
} void busesToolStripMenuItem_Click (object sender, EventArgs e)
{OpenForm=false; (Form Child in this.MdiChildren)
{(Child is FormBuses)
{= true;
}
} (OpenForm)
{index=0; (int x=0; x lt; this.MdiChildren.Length; x ++)
{(MdiChildren [x] .Name == FormBuses )
{= x;
}
} (MdiChildren [index] .Visible == true)
{. MdiChildren [index] .Activate ();
}
{. MdiChildren [index] .WindowState=FormWindowState.Normal; .MdiChildren [index] .Visible=true;
}
}
{FormBuses=new FormBuses () ;. MdiParent=this; _AddToolStrip () ;. Show ();
}
} void conductorsToolStripMenuItem_Click (object sender, EventArgs e)
{OpenForm=false; (Form Child in this.MdiChildren)
{(Child is FormConductors)
{= true;
}
} (OpenForm)
{index=0; (int x=0; x lt; this.MdiChildren.Length; x ++)
{(MdiChildren [x] .Name == FormConductors )
{= x;
}
} (MdiChildren [index] .Visible == true)
{. MdiChildren [index] .Activate ();
}
{. MdiChildren [index] .WindowState=FormWindowState.Normal; .MdiChildren [index] .Visible=true;
}
}
{FormConductors=new FormConductors () ;. MdiParent=this; _AddToolStrip () ;. Show ();
}
} void routesToolStripMenuItem_Click (object sender, EventArgs e)
{OpenForm=false; (Form Child in this.MdiChildren)
{(Child is FormRoutes)
{= true;
}
} (OpenForm)
{index=0; (int x=0; x lt; this.MdiChildren.Length; x ++)
{(MdiChildren [x] .Name == FormRoutes )
{= x;
}
} (MdiChildren [index] .Visible == true)
{. MdiChildren [index] .Activate ();
}
{. MdiChildren [index] .WindowState=FormWindowState.Normal; .MdiChildren [index] .Visible=true;
}
}
{FormRoutes=new FormRoutes () ;. MdiParent=this; _AddToolStrip () ;. Show ();
}
} void пробегАвтобусо...
