/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.e_WorkOrder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_e_WorkOrder set ");
strSql.Append("DrawNum=@DrawNum");
strSql.Append(" where ID_Key=@ID_Key");
SqlParameter[] parameters =
{
new SqlParameter("@DrawNum", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Key", SqlDbType.Decimal, 9),
new SqlParameter("@WorkNum", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.DrawNum;
parameters[1].Value = model.ID_Key;
parameters[2].Value = model.WorkNum;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.e_WorkOrder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_e_WorkOrder(");
strSql.Append("WorkNum,DrawNum)");
strSql.Append(" values (");
strSql.Append("@WorkNum,@DrawNum)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@WorkNum", SqlDbType.VarChar, 50),
new SqlParameter("@DrawNum", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.WorkNum;
parameters[1].Value = model.DrawNum;
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_WorkOrder DataRowToModel(DataRow row)
{
Maticsoft.Model.e_WorkOrder model = new Maticsoft.Model.e_WorkOrder();
if (row != null)
{
if (row["ID_Key"] != null && row["ID_Key"].ToString() != "")
{
model.ID_Key = decimal.Parse(row["ID_Key"].ToString());
}
if (row["WorkNum"] != null)
{
model.WorkNum = row["WorkNum"].ToString();
}
if (row["DrawNum"] != null)
{
model.DrawNum = row["DrawNum"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.e_WorkOrder GetModel(string Order)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID_Key,WorkNum,DrawNum from tb_e_WorkOrder ");
strSql.Append(" where WorkNum=@WorkNum");
SqlParameter[] parameters =
{
new SqlParameter("@WorkNum", SqlDbType.VarChar, 50)
};
parameters[0].Value = Order;
Maticsoft.Model.e_WorkOrder model = new Maticsoft.Model.e_WorkOrder();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}