/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "BPM_WIP";
* parameters[1].Value = "ID_Key";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 获得一个实体
/// </summary>
/// <param name="OrderID"></param>
/// <param name="ProcessID"></param>
/// <returns></returns>
public Model.BPM_WIP GetModel(string OrderID, string ProcessID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from BPM_WIP ");
strSql.Append(" where OrderID='" + OrderID + "' AND ProcessID='" + ProcessID + "'");
MES.Server.Model.BPM_WIP model = new MES.Server.Model.BPM_WIP();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MES.Server.Model.BPM_WIP GetModel(decimal ID_Key)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OrderID,ClientName,ProductName,Spec,Count,ProcessCount,ProcessID,ProcessName,StandardHours,ConnectorQty,ProcessSign,TotalStandatdHours,Qty,Qty_OK,Qty_NG,Qty_NotInput,GetTime,WorkHours,Efficiency,Wip,ID_Key from BPM_WIP ");
strSql.Append(" where ID_Key=@ID_Key");
SqlParameter[] parameters =
{
new SqlParameter("@ID_Key", SqlDbType.Decimal)
};
parameters[0].Value = ID_Key;
MES.Server.Model.BPM_WIP model = new MES.Server.Model.BPM_WIP();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(MES.Server.Model.BPM_WIP model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BPM_WIP(");
strSql.Append("OrderID,ClientName,ProductName,Spec,Count,ProcessCount,ProcessID,ProcessName,StandardHours,ConnectorQty,ProcessSign,TotalStandatdHours,Qty,Qty_OK,Qty_NG,Qty_NotInput,GetTime,WorkHours,Efficiency,Wip)");
strSql.Append(" values (");
strSql.Append("@OrderID,@ClientName,@ProductName,@Spec,@Count,@ProcessCount,@ProcessID,@ProcessName,@StandardHours,@ConnectorQty,@ProcessSign,@TotalStandatdHours,@Qty,@Qty_OK,@Qty_NG,@Qty_NotInput,@GetTime,@WorkHours,@Efficiency,@Wip)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@OrderID", SqlDbType.VarChar, 20),
new SqlParameter("@ClientName", SqlDbType.NChar, 50),
new SqlParameter("@ProductName", SqlDbType.VarChar, 100),
new SqlParameter("@Spec", SqlDbType.VarChar, 100),
new SqlParameter("@Count", SqlDbType.Int, 4),
new SqlParameter("@ProcessCount", SqlDbType.Int, 4),
new SqlParameter("@ProcessID", SqlDbType.VarChar, 20),
new SqlParameter("@ProcessName", SqlDbType.VarChar, 100),
new SqlParameter("@StandardHours", SqlDbType.Float, 8),
new SqlParameter("@ConnectorQty", SqlDbType.Int, 4),
new SqlParameter("@ProcessSign", SqlDbType.VarChar, 30),
new SqlParameter("@TotalStandatdHours", SqlDbType.Float, 8),
new SqlParameter("@Qty", SqlDbType.Int, 4),
new SqlParameter("@Qty_OK", SqlDbType.Int, 4),
new SqlParameter("@Qty_NG", SqlDbType.Int, 4),
new SqlParameter("@Qty_NotInput", SqlDbType.Int, 4),
new SqlParameter("@GetTime", SqlDbType.Float, 8),
new SqlParameter("@WorkHours", SqlDbType.Float, 8),
new SqlParameter("@Efficiency", SqlDbType.Float, 8),
new SqlParameter("@Wip", SqlDbType.Int, 4)
};
parameters[0].Value = model.OrderID;
parameters[1].Value = model.ClientName;
parameters[2].Value = model.ProductName;
parameters[3].Value = model.Spec;
parameters[4].Value = model.Count;
parameters[5].Value = model.ProcessCount;
parameters[6].Value = model.ProcessID;
parameters[7].Value = model.ProcessName;
parameters[8].Value = model.StandardHours;
parameters[9].Value = model.ConnectorQty;
parameters[10].Value = model.ProcessSign;
parameters[11].Value = model.TotalStandatdHours;
parameters[12].Value = model.Qty;
parameters[13].Value = model.Qty_OK;
parameters[14].Value = model.Qty_NG;
parameters[15].Value = model.Qty_NotInput;
parameters[16].Value = model.GetTime;
parameters[17].Value = model.WorkHours;
parameters[18].Value = model.Efficiency;
parameters[19].Value = model.Wip;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MES.Server.Model.BPM_WIP DataRowToModel(DataRow row)
{
MES.Server.Model.BPM_WIP model = new MES.Server.Model.BPM_WIP();
if (row != null)
{
if (row["OrderID"] != null)
{
model.OrderID = row["OrderID"].ToString();
}
if (row["ClientName"] != null)
{
model.ClientName = row["ClientName"].ToString();
}
if (row["ProductName"] != null)
{
model.ProductName = row["ProductName"].ToString();
}
if (row["Spec"] != null)
{
model.Spec = row["Spec"].ToString();
}
if (row["Count"] != null && row["Count"].ToString() != "")
{
model.Count = int.Parse(row["Count"].ToString());
}
if (row["ProcessCount"] != null && row["ProcessCount"].ToString() != "")
{
model.ProcessCount = int.Parse(row["ProcessCount"].ToString());
}
if (row["ProcessID"] != null)
{
model.ProcessID = row["ProcessID"].ToString();
}
if (row["ProcessName"] != null)
{
model.ProcessName = row["ProcessName"].ToString();
}
if (row["StandardHours"] != null && row["StandardHours"].ToString() != "")
{
model.StandardHours = double.Parse(row["StandardHours"].ToString());
}
if (row["ConnectorQty"] != null && row["ConnectorQty"].ToString() != "")
{
model.ConnectorQty = int.Parse(row["ConnectorQty"].ToString());
}
if (row["ProcessSign"] != null)
{
model.ProcessSign = row["ProcessSign"].ToString();
}
if (row["TotalStandatdHours"] != null && row["TotalStandatdHours"].ToString() != "")
{
model.TotalStandatdHours = double.Parse(row["TotalStandatdHours"].ToString());
}
if (row["Qty"] != null && row["Qty"].ToString() != "")
{
model.Qty = int.Parse(row["Qty"].ToString());
}
if (row["Qty_OK"] != null && row["Qty_OK"].ToString() != "")
{
model.Qty_OK = int.Parse(row["Qty_OK"].ToString());
}
if (row["Qty_NG"] != null && row["Qty_NG"].ToString() != "")
{
model.Qty_NG = int.Parse(row["Qty_NG"].ToString());
}
if (row["Qty_NotInput"] != null && row["Qty_NotInput"].ToString() != "")
{
model.Qty_NotInput = int.Parse(row["Qty_NotInput"].ToString());
}
if (row["GetTime"] != null && row["GetTime"].ToString() != "")
{
model.GetTime = double.Parse(row["GetTime"].ToString());
}
if (row["WorkHours"] != null && row["WorkHours"].ToString() != "")
{
model.WorkHours = double.Parse(row["WorkHours"].ToString());
}
if (row["Efficiency"] != null && row["Efficiency"].ToString() != "")
{
model.Efficiency = double.Parse(row["Efficiency"].ToString());
}
if (row["Wip"] != null && row["Wip"].ToString() != "")
{
model.Wip = int.Parse(row["Wip"].ToString());
}
if (row["ID_Key"] != null && row["ID_Key"].ToString() != "")
{
model.ID_Key = double.Parse(row["ID_Key"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MES.Server.Model.BPM_WIP model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BPM_WIP set ");
strSql.Append("OrderID=@OrderID,");
strSql.Append("ClientName=@ClientName,");
strSql.Append("ProductName=@ProductName,");
strSql.Append("Spec=@Spec,");
strSql.Append("Count=@Count,");
strSql.Append("ProcessCount=@ProcessCount,");
strSql.Append("ProcessID=@ProcessID,");
strSql.Append("ProcessName=@ProcessName,");
strSql.Append("StandardHours=@StandardHours,");
strSql.Append("ConnectorQty=@ConnectorQty,");
strSql.Append("ProcessSign=@ProcessSign,");
strSql.Append("TotalStandatdHours=@TotalStandatdHours,");
strSql.Append("Qty=@Qty,");
strSql.Append("Qty_OK=@Qty_OK,");
strSql.Append("Qty_NG=@Qty_NG,");
strSql.Append("Qty_NotInput=@Qty_NotInput,");
strSql.Append("GetTime=@GetTime,");
strSql.Append("WorkHours=@WorkHours,");
strSql.Append("Efficiency=@Efficiency,");
strSql.Append("Wip=@Wip");
strSql.Append(" where ID_Key=@ID_Key");
SqlParameter[] parameters =
{
new SqlParameter("@OrderID", SqlDbType.VarChar, 20),
new SqlParameter("@ClientName", SqlDbType.NChar, 50),
new SqlParameter("@ProductName", SqlDbType.VarChar, 100),
new SqlParameter("@Spec", SqlDbType.VarChar, 100),
new SqlParameter("@Count", SqlDbType.Int, 4),
new SqlParameter("@ProcessCount", SqlDbType.Int, 4),
new SqlParameter("@ProcessID", SqlDbType.VarChar, 20),
new SqlParameter("@ProcessName", SqlDbType.VarChar, 100),
new SqlParameter("@StandardHours", SqlDbType.Float, 8),
new SqlParameter("@ConnectorQty", SqlDbType.Int, 4),
new SqlParameter("@ProcessSign", SqlDbType.VarChar, 30),
new SqlParameter("@TotalStandatdHours", SqlDbType.Float, 8),
new SqlParameter("@Qty", SqlDbType.Int, 4),
new SqlParameter("@Qty_OK", SqlDbType.Int, 4),
new SqlParameter("@Qty_NG", SqlDbType.Int, 4),
new SqlParameter("@Qty_NotInput", SqlDbType.Int, 4),
new SqlParameter("@GetTime", SqlDbType.Float, 8),
new SqlParameter("@WorkHours", SqlDbType.Float, 8),
new SqlParameter("@Efficiency", SqlDbType.Float, 8),
new SqlParameter("@Wip", SqlDbType.Int, 4),
new SqlParameter("@ID_Key", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.OrderID;
parameters[1].Value = model.ClientName;
parameters[2].Value = model.ProductName;
parameters[3].Value = model.Spec;
parameters[4].Value = model.Count;
parameters[5].Value = model.ProcessCount;
parameters[6].Value = model.ProcessID;
parameters[7].Value = model.ProcessName;
parameters[8].Value = model.StandardHours;
parameters[9].Value = model.ConnectorQty;
parameters[10].Value = model.ProcessSign;
parameters[11].Value = model.TotalStandatdHours;
parameters[12].Value = model.Qty;
parameters[13].Value = model.Qty_OK;
parameters[14].Value = model.Qty_NG;
parameters[15].Value = model.Qty_NotInput;
parameters[16].Value = model.GetTime;
parameters[17].Value = model.WorkHours;
parameters[18].Value = model.Efficiency;
parameters[19].Value = model.Wip;
parameters[20].Value = model.ID_Key;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
