private void btn_Save_Click(object sender, EventArgs e)
{
if (txt_GZ.Text.Trim() == "")
{
MessageBox.Show("规则不能未空");
return;
}
if (txt_GZMC.Text.Trim() == "")
{
MessageBox.Show("规则名称不能未空");
return;
}
string strSF = "";//首炉要求
if (this.ck_sfzh.Checked)
{
strSF = ck_sfzh.Text;
}
Mod_TB_BCBZGZ mod = new Mod_TB_BCBZGZ();
mod.C_EMP_ID = RV.UI.UserInfo.UserID;
mod.C_GZ = txt_GZ.Text.Trim();
mod.C_GZMC = txt_GZMC.Text.Trim();
mod.C_SFYS = strSF;
bll.Add(mod);
Query();
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TB_BCBZGZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_BCBZGZ(");
strSql.Append("C_EMP_ID,C_GZMC,C_GZ,C_SFYS)");
strSql.Append(" values (");
strSql.Append(":C_EMP_ID,:C_GZMC,:C_GZ,:C_SFYS)");
OracleParameter[] parameters =
{
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GZMC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GZ", OracleDbType.Varchar2, 1000),
new OracleParameter(":C_SFYS", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_EMP_ID;
parameters[1].Value = model.C_GZMC;
parameters[2].Value = model.C_GZ;
parameters[3].Value = model.C_SFYS;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_BCBZGZ DataRowToModel(DataRow row)
{
Mod_TB_BCBZGZ model = new Mod_TB_BCBZGZ();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].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());
}
if (row["C_GZMC"] != null)
{
model.C_GZMC = row["C_GZMC"].ToString();
}
if (row["C_GZ"] != null)
{
model.C_GZ = row["C_GZ"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_BCBZGZ GetModel(string id)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_EMP_ID,D_MOD_DT,C_GZMC,C_GZ from TB_BCBZGZ ");
strSql.Append(" where C_ID='" + id + "'");
Mod_TB_BCBZGZ model = new Mod_TB_BCBZGZ();
DataSet ds = DbHelperOra.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TB_BCBZGZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TB_BCBZGZ set ");
strSql.Append("C_ID=:C_ID,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_GZMC=:C_GZMC,");
strSql.Append("C_GZ=:C_GZ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_GZMC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GZ", OracleDbType.Varchar2, 1000)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_EMP_ID;
parameters[2].Value = model.D_MOD_DT;
parameters[3].Value = model.C_GZMC;
parameters[4].Value = model.C_GZ;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TB_BCBZGZ model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TB_BCBZGZ 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();
}
