private void btn_Save_Click(object sender, EventArgs e)
{
DateTime st = de_ST.DateTime;
DateTime et = de_ET.DateTime;
var aa = et - st;
var bbb = aa.TotalHours;
var list1 = cbo_BC.Properties.Items.ToList();
var list2 = cbo_BZ.Properties.Items.ToList();
int startbc = 0;
int startbz = 0;
bll_TB_BCBZ.Delete(st, cbo_GX2.EditValue.ToString());
for (int i = 0; i < list1.Count; i++)
{
if (cbo_BC.EditValue.ToString() == list1[i].Value.ToString())
{
startbc = i;
break;
}
}
for (int i = 0; i < list2.Count; i++)
{
if (cbo_BZ.EditValue.ToString() == list2[i].Value.ToString())
{
startbz = i;
break;
}
}
int hours = (24 / Convert.ToInt32(cbo_PBSL.Text));
for (int i = 1; i < Math.Ceiling(bbb / hours); i++)
{
Mod_TB_BCBZ mod_TB_BCBZ = new Mod_TB_BCBZ();
mod_TB_BCBZ.C_PRO_ID = cbo_GX2.EditValue.ToString();
mod_TB_BCBZ.C_BC = list1[startbc].Value.ToString();
mod_TB_BCBZ.C_BZ = list2[startbz].Value.ToString();
mod_TB_BCBZ.D_START = st;
mod_TB_BCBZ.D_END = st.AddHours(hours);
mod_TB_BCBZ.C_EMP_ID = RV.UI.UserInfo.userID;
bll_TB_BCBZ.Add(mod_TB_BCBZ);
st = st.AddHours(hours);
if (startbc == list1.Count - 1)
{
startbc = -1;
}
if (startbz == list2.Count - 1)
{
startbz = -1;
}
startbc++;
startbz++;
}
cbo_GX2.EditValue = cbo_GX.EditValue;
MessageBox.Show("保存成功");
Query();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TB_BCBZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TB_BCBZ set ");
strSql.Append("D_START=:D_START,");
strSql.Append("D_END=:D_END,");
strSql.Append("C_BC=:C_BC,");
strSql.Append("C_BZ=:C_BZ,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":D_START", OracleDbType.Date),
new OracleParameter(":D_END", OracleDbType.Date),
new OracleParameter(":C_BC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.D_START;
parameters[1].Value = model.D_END;
parameters[2].Value = model.C_BC;
parameters[3].Value = model.C_BZ;
parameters[4].Value = model.C_EMP_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TB_BCBZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_BCBZ(");
strSql.Append("D_START,D_END,C_BC,C_BZ,C_EMP_ID,D_MOD_DT,C_PRO_ID,C_GZ)");
strSql.Append(" values (");
strSql.Append(":D_START,:D_END,:C_BC,:C_BZ,:C_EMP_ID,:D_MOD_DT,:C_PRO_ID,:C_GZ)");
OracleParameter[] parameters =
{
new OracleParameter(":D_START", OracleDbType.Date),
new OracleParameter(":D_END", OracleDbType.Date),
new OracleParameter(":C_BC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_PRO_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GZ", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.D_START;
parameters[1].Value = model.D_END;
parameters[2].Value = model.C_BC;
parameters[3].Value = model.C_BZ;
parameters[4].Value = model.C_EMP_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.C_PRO_ID;
parameters[7].Value = model.C_GZ;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_BCBZ DataRowToModel(DataRow row)
{
Mod_TB_BCBZ model = new Mod_TB_BCBZ();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["D_START"] != null && row["D_START"].ToString() != "")
{
model.D_START = DateTime.Parse(row["D_START"].ToString());
}
if (row["D_END"] != null && row["D_END"].ToString() != "")
{
model.D_END = DateTime.Parse(row["D_END"].ToString());
}
if (row["C_BC"] != null)
{
model.C_BC = row["C_BC"].ToString();
}
if (row["C_BZ"] != null)
{
model.C_BZ = row["C_BZ"].ToString();
}
if (row["C_EMP_ID"] != null)
{
model.C_EMP_ID = row["C_EMP_ID"].ToString();
}
if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "")
{
model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_BCBZ GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,D_START,D_END,C_BC,C_BZ,C_EMP_ID,D_MOD_DT from TB_BCBZ ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TB_BCBZ model = new Mod_TB_BCBZ();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TB_BCBZ model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TB_BCBZ model)
{
return(dal.Add(model));
}
private void btn_ZXGZ_Click(object sender, EventArgs e)
{
WaitingFrom.ShowWait("");
string gzmc = cbo_GZ.Text.ToString();
Mod_TB_BCBZGZ mod = bll.GetModel(cbo_GZ.EditValue.ToString());
string gz1 = mod.C_GZ;
string gzn = mod.C_GZ;
DateTime st = de_ST.DateTime;
DateTime et = de_ET.DateTime;
var aa = et - st;
var bbb = aa.TotalHours;
var list1 = cbo_BC.Properties.Items.ToList();
var list2 = cbo_BZ.Properties.Items.ToList();
int startbc = 0;
int startbz = 0;
int hours = (24 / Convert.ToInt32(cbo_PBSL.Text));
double sumbc = Math.Ceiling(bbb / hours); //获取时间段总班次次数
double sumgz = Math.Ceiling(sumbc / gz1.Length) - 1; //获取时间段规则周期次数
double sybcsl = sumbc % gz1.Length;
bll_TB_BCBZ.Delete(st, cbo_GX2.EditValue.ToString());
double sss = Math.Ceiling(10.001);
for (int i = 0; i < list1.Count; i++)
{
if (cbo_BC.EditValue.ToString() == list1[i].Value.ToString())
{
startbc = i;
break;
}
}
for (int i = 0; i < list2.Count; i++)
{
if (cbo_BZ.EditValue.ToString() == list2[i].Value.ToString())
{
startbz = i;
break;
}
}
int b = 0;
DataTable dt = bll_TB_BCBZ.GetLastList(cbo_GX.EditValue.ToString(), de_ST1.DateTime).Tables[0];
string lastgz = dt.Rows[0]["C_BZ_NAME"].ToString();
if (lastgz == "甲")
{
lastgz = "1";
}
else
if (lastgz == "乙")
{
lastgz = "2";
}
else
if (lastgz == "丙")
{
lastgz = "3";
}
else
if (lastgz == "丁")
{
lastgz = "4";
}
int c = 0;
if (cbo_BZ.Text == "甲")
{
c = 1;
}
else
if (cbo_BZ.Text == "乙")
{
c = 2;
}
else
if (cbo_BZ.Text == "丙")
{
c = 3;
}
else
if (cbo_BZ.Text == "丁")
{
c = 4;
}
//获取首次规则排班
for (int i = 0; i < gz1.Length; i++)
{
string bz = gz1.Substring(0, 1);
if (b == 0)
{
if (Convert.ToInt32(bz) != c)
{
gz1 = gz1.Substring(Convert.ToInt32(cbo_PBSL.Text), gz1.Length - Convert.ToInt32(cbo_PBSL.Text));
continue;
}
else
{
b = 1;
continue;
}
}
}
if (sumgz == 0)
{
//首次规则排班
for (int i = 0; i < sybcsl; i++)
{
int bz = Convert.ToInt32(gz1.Substring(i, 1));
Mod_TB_BCBZ mod_TB_BCBZ = new Mod_TB_BCBZ();
mod_TB_BCBZ.C_PRO_ID = cbo_GX2.EditValue.ToString();
mod_TB_BCBZ.C_BC = list1[startbc].Value.ToString();
mod_TB_BCBZ.C_BZ = list2[bz - 1].Value.ToString();
mod_TB_BCBZ.D_START = st;
mod_TB_BCBZ.D_END = st.AddHours(hours);
mod_TB_BCBZ.C_EMP_ID = RV.UI.UserInfo.userID;
mod_TB_BCBZ.C_GZ = gzmc;
bll_TB_BCBZ.Add(mod_TB_BCBZ);
st = st.AddHours(hours);
if (startbc == list1.Count - 1)
{
startbc = -1;
}
startbc++;
}
}
else
{
//首次规则排班
for (int i = 0; i < gz1.Length; i++)
{
int bz = Convert.ToInt32(gz1.Substring(i, 1));
Mod_TB_BCBZ mod_TB_BCBZ = new Mod_TB_BCBZ();
mod_TB_BCBZ.C_PRO_ID = cbo_GX2.EditValue.ToString();
mod_TB_BCBZ.C_BC = list1[startbc].Value.ToString();
mod_TB_BCBZ.C_BZ = list2[bz - 1].Value.ToString();
mod_TB_BCBZ.D_START = st;
mod_TB_BCBZ.D_END = st.AddHours(hours);
mod_TB_BCBZ.C_EMP_ID = RV.UI.UserInfo.userID;
mod_TB_BCBZ.C_GZ = gzmc;
bll_TB_BCBZ.Add(mod_TB_BCBZ);
st = st.AddHours(hours);
if (startbc == list1.Count - 1)
{
startbc = -1;
}
startbc++;
}
if (sumgz != 1)
{
for (int a = 0; a < sumgz; a++)
{
for (int i = 0; i < gzn.Length; i++)
{
int bz = Convert.ToInt32(gzn.Substring(i, 1));
Mod_TB_BCBZ mod_TB_BCBZ = new Mod_TB_BCBZ();
mod_TB_BCBZ.C_PRO_ID = cbo_GX2.EditValue.ToString();
mod_TB_BCBZ.C_BC = list1[startbc].Value.ToString();
mod_TB_BCBZ.C_BZ = list2[bz - 1].Value.ToString();
mod_TB_BCBZ.D_START = st;
mod_TB_BCBZ.D_END = st.AddHours(hours);
mod_TB_BCBZ.C_EMP_ID = RV.UI.UserInfo.userID;
mod_TB_BCBZ.C_GZ = gzmc;
bll_TB_BCBZ.Add(mod_TB_BCBZ);
st = st.AddHours(hours);
if (startbc == list1.Count - 1)
{
startbc = -1;
}
startbc++;
}
}
}
//尾次规则排班
for (int i = 0; i < sybcsl; i++)
{
int bz = Convert.ToInt32(gzn.Substring(i, 1));
Mod_TB_BCBZ mod_TB_BCBZ = new Mod_TB_BCBZ();
mod_TB_BCBZ.C_PRO_ID = cbo_GX2.EditValue.ToString();
mod_TB_BCBZ.C_BC = list1[startbc].Value.ToString();
mod_TB_BCBZ.C_BZ = list2[bz - 1].Value.ToString();
mod_TB_BCBZ.D_START = st;
mod_TB_BCBZ.D_END = st.AddHours(hours);
mod_TB_BCBZ.C_GZ = gzmc;
mod_TB_BCBZ.C_EMP_ID = RV.UI.UserInfo.userID;
bll_TB_BCBZ.Add(mod_TB_BCBZ);
st = st.AddHours(hours);
if (startbc == list1.Count - 1)
{
startbc = -1;
}
startbc++;
}
}
cbo_GX2.EditValue = cbo_GX.EditValue;
MessageBox.Show("保存成功");
WaitingFrom.CloseWait();
Query();
}
