/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_ROLL_TIME DataRowToModel(DataRow row)
{
Mod_TRC_ROLL_TIME model = new Mod_TRC_ROLL_TIME();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_STA_ID"] != null)
{
model.C_STA_ID = row["C_STA_ID"].ToString();
}
if (row["C_RQ"] != null)
{
model.C_RQ = row["C_RQ"].ToString();
}
if (row["N_NUM_GRD"] != null && row["N_NUM_GRD"].ToString() != "")
{
model.N_NUM_GRD = decimal.Parse(row["N_NUM_GRD"].ToString());
}
if (row["N_NUM_SPEC"] != null && row["N_NUM_SPEC"].ToString() != "")
{
model.N_NUM_SPEC = decimal.Parse(row["N_NUM_SPEC"].ToString());
}
if (row["C_TIME_SPEC"] != null)
{
model.C_TIME_SPEC = row["C_TIME_SPEC"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool AddTran(Mod_TRC_ROLL_TIME model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_ROLL_TIME(");
strSql.Append("C_STA_ID,C_RQ,N_NUM_GRD,N_NUM_SPEC,C_TIME_SPEC)");
strSql.Append(" values (");
strSql.Append(":C_STA_ID,:C_RQ,:N_NUM_GRD,:N_NUM_SPEC,:C_TIME_SPEC)");
OracleParameter[] parameters =
{
new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_RQ", OracleDbType.Varchar2, 100),
new OracleParameter(":N_NUM_GRD", OracleDbType.Decimal, 10),
new OracleParameter(":N_NUM_SPEC", OracleDbType.Decimal, 10),
new OracleParameter(":C_TIME_SPEC", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_STA_ID;
parameters[1].Value = model.C_RQ;
parameters[2].Value = model.N_NUM_GRD;
parameters[3].Value = model.N_NUM_SPEC;
parameters[4].Value = model.C_TIME_SPEC;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取记录总数
/// </summary>
public Mod_TRC_ROLL_TIME Get_Model(string C_STA_ID, string RQ)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STA_ID,C_RQ,N_NUM_GRD,N_NUM_SPEC,C_TIME_SPEC from TRC_ROLL_TIME tt ");
strSql.Append(" WHERE TT.C_STA_ID = '" + C_STA_ID + "' AND TT.C_RQ = '" + RQ + "' ");
Mod_TRC_ROLL_TIME model = new Mod_TRC_ROLL_TIME();
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 UpdateTran(Mod_TRC_ROLL_TIME model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_ROLL_TIME set ");
strSql.Append("C_STA_ID=:C_STA_ID,");
strSql.Append("C_RQ=:C_RQ,");
strSql.Append("N_NUM_GRD=:N_NUM_GRD,");
strSql.Append("N_NUM_SPEC=:N_NUM_SPEC,");
strSql.Append("C_TIME_SPEC=:C_TIME_SPEC");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_RQ", OracleDbType.Varchar2, 100),
new OracleParameter(":N_NUM_GRD", OracleDbType.Decimal, 10),
new OracleParameter(":N_NUM_SPEC", OracleDbType.Decimal, 10),
new OracleParameter(":C_TIME_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_STA_ID;
parameters[1].Value = model.C_RQ;
parameters[2].Value = model.N_NUM_GRD;
parameters[3].Value = model.N_NUM_SPEC;
parameters[4].Value = model.C_TIME_SPEC;
parameters[5].Value = model.C_ID;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_ROLL_TIME GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STA_ID,C_RQ,N_NUM_GRD,N_NUM_SPEC,C_TIME_SPEC from TRC_ROLL_TIME ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_ROLL_TIME model = new Mod_TRC_ROLL_TIME();
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>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_TB_Click(object sender, EventArgs e)
{
try
{
DataTable dt = bllTrcRollProduct.GetList_WGD().Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
Mod_TRC_ROLL_TIME model = bllTrcRollTime.Get_Model(dt.Rows[i]["C_STA_ID"].ToString(), dt.Rows[i]["RQ"].ToString());
if (model == null)
{
model = new Mod_TRC_ROLL_TIME();
model.C_STA_ID = dt.Rows[i]["C_STA_ID"].ToString();
model.C_RQ = dt.Rows[i]["RQ"].ToString();
model.N_NUM_GRD = 1;
model.N_NUM_SPEC = 1;
model.C_TIME_SPEC = "0";
if (!bllTrcRollTime.Add(model))
{
MessageBox.Show("操作失败！");
return;
}
}
else
{
if (dt.Rows[i]["C_STA_ID"].ToString() == dt.Rows[i - 1]["C_STA_ID"].ToString())
{
if (dt.Rows[i]["C_STL_GRD"].ToString() != dt.Rows[i - 1]["C_STL_GRD"].ToString())
{
model.N_NUM_GRD = model.N_NUM_GRD + 1;
}
if (dt.Rows[i]["C_SPEC"].ToString() != dt.Rows[i - 1]["C_SPEC"].ToString())
{
model.N_NUM_SPEC = model.N_NUM_SPEC + 1;
int time = bllTpbChangSpecTime.Get_Time2(dt.Rows[i]["C_STA_ID"].ToString(), dt.Rows[i - 1]["C_SPEC"].ToString(), dt.Rows[i]["C_SPEC"].ToString());
model.C_TIME_SPEC = (Convert.ToInt32(model.C_TIME_SPEC) + time).ToString();
}
if (!bllTrcRollTime.Update(model))
{
MessageBox.Show("操作失败！");
return;
}
}
else
{
model.N_NUM_GRD = 1;
model.N_NUM_SPEC = 1;
model.C_TIME_SPEC = "0";
if (!bllTrcRollTime.Update(model))
{
MessageBox.Show("操作失败！");
return;
}
}
}
}
MessageBox.Show("操作成功！");
btn_Query_Click(null, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_ROLL_TIME model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_TIME model)
{
return(dal.Add(model));
}
