/// <summary>
/// 开始建模
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_start_Click(object sender, EventArgs e)
{
if (isSave == false)
{
Msg.Box.Show("请先保存设定的值！");
return;
}
Entity.Pay p = new Entity.Pay();
p.payTime = System.DateTime.Now;
if (BLL.SalaryBLL.IsHave(p) == true)
{
Msg.Box.Show("下月的工资单已存在，请勿重复添加！");
return;
}
try
{
this.pgr_go.Enabled = true;
BLL.SalaryBLL.MakeMode();
this.pgr_go.Value = 100;
this.pgr_go.Enabled = false;
Msg.Box.Show("恭喜您，建模成功！");
}
catch (Exception ex)
{
Msg.Box.Show(ex.Message);
return;
}
}
////按月份执行
/// <summary>
/// 按月份部门查询 利用pID传递部门编号
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public static DataTable FindByMDep(Entity.Pay p)
{
Entity.MoneyModel mm = OpenSet();
allDayAdd = mm.allAdd;
goDay = mm.goDay;
DataTable dt = DAL.SalaryDAL.FindByMDep(p);
SalaryBLL.CountMoney(dt);
return(dt);
}
/// <summary>
/// 是否存在下月模
/// </summary>
/// <returns></returns>
public static bool IsHave(Entity.Pay p)
{
if ((int)DAL.SalaryDAL.IsHave(p) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新信息状态
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static void UpState(Entity.Pay p)
{
DAL.LeaveDAL.UpPState(p);
}
/// <summary>
/// 按实际发放工资段查询 利用payDel传递最小值 payAdd传递最大值
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static DataTable FindByMoney(Entity.Pay p)
{
string sql = "select PayID,PName,Pay.PID,PayAll,PayBase,PayAllDay,PayDay,PayAdd,PayDel,PayIn,PayTime from Pay,Person where Pay.PID=Person.PID and ( PayIn between " + p.payDel + " and " + p.payAdd + " ) and Person.PState='正式'";
return(DBHelper.GetDT(sql));
}
///不按月份执行
/// <summary>
/// 按部门查询 利用pID传递部门编号
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public static DataTable FindByDep(Entity.Pay p)
{
string sql = "select PayID,PName,Pay.PID,PayAll,PayBase,PayAllDay,PayDay,PayAdd,PayDel,PayIn,PayTime from Pay,Person,Job where Pay.PID=Person.PID and Person.JID=Job.JID and Job.DepID=" + p.pID + " and Person.PState='正式'";
return(DBHelper.GetDT(sql));
}
/// <summary>
/// 按月份工号查询
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static DataTable FindByMPID(Entity.Pay p)
{
string sql = "select PayID,PName,Pay.PID,PayAll,PayBase,PayAllDay,PayDay,PayAdd,PayDel,PayIn,PayTime from Pay,Person where Pay.PID=Person.PID and year(PayTime)=" + p.payTime.ToString("yyyy") + "and month(PayTime)=" + p.payTime.ToString("MM") + " and Pay.PID=" + p.pID + " and Person.PState='正式'";
return(DBHelper.GetDT(sql));
}
/// <summary>
/// 是否存在下月模
/// </summary>
/// <returns></returns>
public static object IsHave(Entity.Pay p)
{
string sql = "select count(*) from Pay where year(PayTime)=" + p.payTime.Year + " and MONTH(PayTime)=" + (p.payTime.Month + 1) + "";
return(DBHelper.GetScalar(sql));
}
/// <summary>
/// 更新信息状态
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static int UpPState(Entity.Pay p)
{
string sql = "update Person set PState='休假' where PID=" + p.pID + "";
return(DBHelper.GetLine(sql));
}
