/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.MixHistory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MixHistory(");
strSql.Append("ID,PART_ID,MIX_DATETIME,MIX_TIME,MIX_BY,REMARK)");
strSql.Append(" values (");
strSql.Append("@ID,@PART_ID,@MIX_DATETIME,@MIX_TIME,@MIX_BY,@REMARK)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@PART_ID", SqlDbType.VarChar, 50),
new SqlParameter("@MIX_DATETIME", SqlDbType.DateTime),
new SqlParameter("@MIX_TIME", SqlDbType.Decimal, 9),
new SqlParameter("@MIX_BY", SqlDbType.VarChar, 50),
new SqlParameter("@REMARK", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.PART_ID;
parameters[2].Value = model.MIX_DATETIME;
parameters[3].Value = model.MIX_TIME;
parameters[4].Value = model.MIX_BY;
parameters[5].Value = model.REMARK;
int rows = Common.DB.SqlDB.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.MixHistory DataRowToModel(DataRow row)
{
Model.MixHistory model = new Model.MixHistory();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["PART_ID"] != null)
{
model.PART_ID = row["PART_ID"].ToString();
}
if (row["MIX_DATETIME"] != null && row["MIX_DATETIME"].ToString() != "")
{
model.MIX_DATETIME = DateTime.Parse(row["MIX_DATETIME"].ToString());
}
if (row["MIX_TIME"] != null && row["MIX_TIME"].ToString() != "")
{
model.MIX_TIME = decimal.Parse(row["MIX_TIME"].ToString());
}
if (row["MIX_BY"] != null)
{
model.MIX_BY = row["MIX_BY"].ToString();
}
if (row["REMARK"] != null)
{
model.REMARK = row["REMARK"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.MixHistory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MixHistory set ");
strSql.Append("ID=@ID,");
strSql.Append("PART_ID=@PART_ID,");
strSql.Append("MIX_DATETIME=@MIX_DATETIME,");
strSql.Append("MIX_TIME=@MIX_TIME,");
strSql.Append("MIX_BY=@MIX_BY,");
strSql.Append("REMARK=@REMARK");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@PART_ID", SqlDbType.VarChar, 50),
new SqlParameter("@MIX_DATETIME", SqlDbType.DateTime),
new SqlParameter("@MIX_TIME", SqlDbType.Decimal, 9),
new SqlParameter("@MIX_BY", SqlDbType.VarChar, 50),
new SqlParameter("@REMARK", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.PART_ID;
parameters[2].Value = model.MIX_DATETIME;
parameters[3].Value = model.MIX_TIME;
parameters[4].Value = model.MIX_BY;
parameters[5].Value = model.REMARK;
int rows = Common.DB.SqlDB.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.MixHistory GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,PART_ID,MIX_DATETIME,MIX_TIME,MIX_BY,REMARK from MixHistory ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Model.MixHistory model = new Model.MixHistory();
DataTable dt = Common.DB.SqlDB.Query(strSql.ToString(), parameters);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
else
{
return(DataRowToModel(dt.Rows[0]));
}
}
public SqlCommand AddCommand(Model.MixHistory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MixHistory(");
strSql.Append("PART_ID,MIX_DATETIME,MIX_TIME,MIX_BY,REMARK)");
strSql.Append(" values (");
strSql.Append("@PART_ID,@MIX_DATETIME,@MIX_TIME,@MIX_BY,@REMARK)");
SqlParameter[] parameters =
{
new SqlParameter("@PART_ID", SqlDbType.VarChar, 50),
new SqlParameter("@MIX_DATETIME", SqlDbType.DateTime),
new SqlParameter("@MIX_TIME", SqlDbType.Decimal, 9),
new SqlParameter("@MIX_BY", SqlDbType.VarChar, 50),
new SqlParameter("@REMARK", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.PART_ID;
parameters[1].Value = model.MIX_DATETIME;
parameters[2].Value = model.MIX_TIME;
parameters[3].Value = model.MIX_BY;
parameters[4].Value = model.REMARK;
return(Common.DB.SqlDB.GenerateCommand(strSql.ToString(), parameters));
}
private bool Update(Model.Tracking trackModel, Model.History hisModel, Model.MixHistory mixModel)
{
BLL.MixHistory mixBLL = new BLL.MixHistory();
BLL.Tracking trackBLL = new BLL.Tracking();
BLL.History hisBLL = new BLL.History();
List <SqlCommand> cmdList = new List <SqlCommand>();
if (trackModel != null)
{
cmdList.Add(trackBLL.UpdateCommand(trackModel));
}
if (hisModel != null)
{
cmdList.Add(hisBLL.AddCommand(hisModel));
}
cmdList.Add(mixBLL.AddCommand(mixModel));
return(Common.DB.SqlDB.SetData_Rollback(cmdList, Common.DB.Connection.SqlServer.EMS));
}
private void BackgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
//检测 是否把epoxy拿了出来.
//bool isMaterialIn = Hardware.IO_LIST.Input.X207_Mix_Material_In();
//while (isMaterialIn)
//{
// MessageBox.Show("Mixing complete, please open door and take out epoxy!");
// //重新检下测感应器状态.
// isMaterialIn = Hardware.IO_LIST.Input.X207_Mix_Material_In();
//}
//更新数据库
Model.MixHistory mixModel = new Model.MixHistory();
mixModel.PART_ID = this.txt_partID_input.Text;
mixModel.MIX_TIME = decimal.Parse(mixTime.ToString());
mixModel.MIX_DATETIME = DateTime.Now;
mixModel.MIX_BY = this.txt_userID.Text;
mixModel.REMARK = "";
BLL.Tracking trackBLL = new BLL.Tracking();
Model.Tracking trackModel = trackBLL.GetModel(this.txt_partID.Text);
if (trackModel != null)
{
trackModel.STATUS = StaticRes.Global.Status.Unload;
trackModel.UPDATED_TIME = DateTime.Now;
trackModel.ACTION = "Mix";
}
BLL.History hisBLL = new BLL.History();
Model.History hisModel = hisBLL.CopyTrackModel(trackModel);
if (!Update(trackModel, hisModel, mixModel))
{
MessageBox.Show("Update database fail!");
Common.Reports.LogFile.Log("[Mix] [BackgroundWorker_RunWorkerCompleted] - Update database fail partID:" + this.txt_partID.Text);
}
//init 变量
onGoing = false;
runningTime = 0;
this.pb.Value = 0;
//init ui
InitMaterialInfo();
this.txt_partID_input.Text = "";
this.txt_partID_input.IsEnabled = true;
this.txt_partID_input.Focus();
this.txt_partID_input.Background = StaticRes.ColorBrushes.Linear_Green;
ShowWindow();
this.txt_Msg.Text = "搅拌完成, 请取出后关闭或继续搅拌.";
}
