/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.e_ProcessFlow model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_e_ProcessFlow(");
strSql.Append("BarCode,ProNum,ProcessName,ProcessContent,Value,JobNum,UserName,DateTime,State,Remarks,R1,R2,R3,R4,R5)");
strSql.Append(" values (");
strSql.Append("@BarCode,@ProNum,@ProcessName,@ProcessContent,@Value,@JobNum,@UserName,@DateTime,@State,@Remarks,@R1,@R2,@R3,@R4,@R5)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@BarCode", SqlDbType.VarChar, 50),
new SqlParameter("@ProNum", SqlDbType.VarChar, 50),
new SqlParameter("@ProcessName", SqlDbType.VarChar, 150),
new SqlParameter("@ProcessContent", SqlDbType.VarChar, 150),
new SqlParameter("@Value", SqlDbType.VarChar, 150),
new SqlParameter("@JobNum", SqlDbType.VarChar, 50),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@DateTime", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.VarChar, 150),
new SqlParameter("@Remarks", SqlDbType.VarChar, 1),
new SqlParameter("@R1", SqlDbType.VarChar, 150),
new SqlParameter("@R2", SqlDbType.VarChar, 150),
new SqlParameter("@R3", SqlDbType.VarChar, 150),
new SqlParameter("@R4", SqlDbType.VarChar, 150),
new SqlParameter("@R5", SqlDbType.VarChar, 150)
};
parameters[0].Value = model.BarCode;
parameters[1].Value = model.ProNum;
parameters[2].Value = model.ProcessName;
parameters[3].Value = model.ProcessContent;
parameters[4].Value = model.Value;
parameters[5].Value = model.JobNum;
parameters[6].Value = model.UserName;
parameters[7].Value = model.DateTime;
parameters[8].Value = model.State;
parameters[9].Value = model.Remarks;
parameters[10].Value = model.R1;
parameters[11].Value = model.R2;
parameters[12].Value = model.R3;
parameters[13].Value = model.R4;
parameters[14].Value = model.R5;
object obj = dbs.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 验证工序是否可以保存
/// </summary>
/// <param name="Barcode">条码</param>
/// <param name="_ProcessFlow">待保存的工序信息</param>
/// <param name="_MaxProcessOrder">已保存的最大工序的顺序编号</param>
/// <param name="IsBelong">该工序是否属于此条码</param>
/// <param name="IsYetSave">是否已经保存过此工序</param>
/// <param name="IsUpProcessSave">上工序是否已经完成</param>
/// <param name="IsBarcodeNull">条码是否为空</param>
/// <returns></returns>
public void VerifyBarcode(string Barcode, Maticsoft.Model.e_ProcessFlow _ProcessFlow, int _MaxProcessOrder, out bool IsBelong, out bool IsYetSave, out bool IsUpProcessSave, out bool IsBarcodeNull)
{
/*1.根据条码获取工单
* 2.根据工单获取图纸编号
* 3.根据图纸编号获取工序列表
* 4.验证 此工序是否属于该工单
* 5.验证 此工序的上工序是否已经完成
* 6.验证 此工序是否已经做过 目前设定（如果做过忽略警告，正常保存）
*/
Maticsoft.BLL.SerialNumber MserialNumber = new Maticsoft.BLL.SerialNumber();
Maticsoft.BLL.e_Flow Mflow = new Maticsoft.BLL.e_Flow();
Maticsoft.BLL.e_WorkOrder MworkOrder = new Maticsoft.BLL.e_WorkOrder();
Maticsoft.BLL.e_ProcessFlow MprocessFlow = new Maticsoft.BLL.e_ProcessFlow();
Maticsoft.Model.SerialNumber SerialNumber = MserialNumber.GetModel(Barcode); //条码
if (SerialNumber != null)
{
Maticsoft.Model.e_WorkOrder WorkOrder = MworkOrder.GetModel(SerialNumber.OrderID); //工单
//根据条码获取的工单中对应的图纸编号 获取该编号所有的工序
List <Maticsoft.Model.e_Flow> flowList = Mflow.GetModelList("DrawNum = '" + WorkOrder.DrawNum + "'").ToList();
IsBelong = false;
foreach (Maticsoft.Model.e_Flow tem in flowList)
{
if (tem.ProcessNum == _ProcessFlow.ProNum)
{
IsBelong = true;
} //该工序是否存在
}
IsYetSave = (int.Parse(_ProcessFlow.R1) == _MaxProcessOrder ? true : false); //是否已经保存此工序
IsUpProcessSave = (int.Parse(_ProcessFlow.R1) - 1 == _MaxProcessOrder ? true : false); //上工序是否已完成
IsBarcodeNull = true;
}
else
{
IsBarcodeNull = false;
IsYetSave = true;
IsBelong = true;
IsUpProcessSave = true;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.e_ProcessFlow GetModel(decimal ID_Key)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID_Key,BarCode,ProNum,ProcessName,ProcessContent,Value,JobNum,UserName,DateTime,State,Remarks,R1,R2,R3,R4,R5 from tb_e_ProcessFlow ");
strSql.Append(" where ID_Key=@ID_Key");
SqlParameter[] parameters =
{
new SqlParameter("@ID_Key", SqlDbType.Decimal)
};
parameters[0].Value = ID_Key;
Maticsoft.Model.e_ProcessFlow model = new Maticsoft.Model.e_ProcessFlow();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.e_ProcessFlow DataRowToModel(DataRow row)
{
Maticsoft.Model.e_ProcessFlow model = new Maticsoft.Model.e_ProcessFlow();
if (row != null)
{
if (row["ID_Key"] != null && row["ID_Key"].ToString() != "")
{
model.ID_Key = decimal.Parse(row["ID_Key"].ToString());
}
if (row["BarCode"] != null)
{
model.BarCode = row["BarCode"].ToString();
}
if (row["ProNum"] != null)
{
model.ProNum = row["ProNum"].ToString();
}
if (row["ProcessName"] != null)
{
model.ProcessName = row["ProcessName"].ToString();
}
if (row["ProcessContent"] != null)
{
model.ProcessContent = row["ProcessContent"].ToString();
}
if (row["Value"] != null)
{
model.Value = row["Value"].ToString();
}
if (row["JobNum"] != null)
{
model.JobNum = row["JobNum"].ToString();
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["DateTime"] != null && row["DateTime"].ToString() != "")
{
model.DateTime = DateTime.Parse(row["DateTime"].ToString());
}
if (row["State"] != null)
{
model.State = row["State"].ToString();
}
if (row["Remarks"] != null)
{
model.Remarks = row["Remarks"].ToString();
}
if (row["R1"] != null)
{
model.R1 = row["R1"].ToString();
}
if (row["R2"] != null)
{
model.R2 = row["R2"].ToString();
}
if (row["R3"] != null)
{
model.R3 = row["R3"].ToString();
}
if (row["R4"] != null)
{
model.R4 = row["R4"].ToString();
}
if (row["R5"] != null)
{
model.R5 = row["R5"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.e_ProcessFlow model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_e_ProcessFlow set ");
strSql.Append("BarCode=@BarCode,");
strSql.Append("ProNum=@ProNum,");
strSql.Append("ProcessName=@ProcessName,");
strSql.Append("ProcessContent=@ProcessContent,");
strSql.Append("Value=@Value,");
strSql.Append("JobNum=@JobNum,");
strSql.Append("UserName=@UserName,");
strSql.Append("DateTime=@DateTime,");
strSql.Append("State=@State,");
strSql.Append("Remarks=@Remarks,");
strSql.Append("R1=@R1,");
strSql.Append("R2=@R2,");
strSql.Append("R3=@R3,");
strSql.Append("R4=@R4,");
strSql.Append("R5=@R5");
strSql.Append(" where ID_Key=@ID_Key");
SqlParameter[] parameters =
{
new SqlParameter("@BarCode", SqlDbType.VarChar, 50),
new SqlParameter("@ProNum", SqlDbType.VarChar, 50),
new SqlParameter("@ProcessName", SqlDbType.VarChar, 150),
new SqlParameter("@ProcessContent", SqlDbType.VarChar, 150),
new SqlParameter("@Value", SqlDbType.VarChar, 150),
new SqlParameter("@JobNum", SqlDbType.VarChar, 50),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@DateTime", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.VarChar, 150),
new SqlParameter("@Remarks", SqlDbType.VarChar, 1),
new SqlParameter("@R1", SqlDbType.VarChar, 150),
new SqlParameter("@R2", SqlDbType.VarChar, 150),
new SqlParameter("@R3", SqlDbType.VarChar, 150),
new SqlParameter("@R4", SqlDbType.VarChar, 150),
new SqlParameter("@R5", SqlDbType.VarChar, 150),
new SqlParameter("@ID_Key", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.BarCode;
parameters[1].Value = model.ProNum;
parameters[2].Value = model.ProcessName;
parameters[3].Value = model.ProcessContent;
parameters[4].Value = model.Value;
parameters[5].Value = model.JobNum;
parameters[6].Value = model.UserName;
parameters[7].Value = model.DateTime;
parameters[8].Value = model.State;
parameters[9].Value = model.Remarks;
parameters[10].Value = model.R1;
parameters[11].Value = model.R2;
parameters[12].Value = model.R3;
parameters[13].Value = model.R4;
parameters[14].Value = model.R5;
parameters[15].Value = model.ID_Key;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
