/// <summary>
/// 得到一个对象实体
/// </summary>
public WMS_Database.View_CellModel DataRowToModel(DataRow row)
{
WMS_Database.View_CellModel model = new WMS_Database.View_CellModel();
if (row != null)
{
if (row["WareHouse_Code"] != null)
{
model.WareHouse_Code = row["WareHouse_Code"].ToString();
}
if (row["WareHouse_Name"] != null)
{
model.WareHouse_Name = row["WareHouse_Name"].ToString();
}
if (row["WareHouse_Flag"] != null)
{
model.WareHouse_Flag = row["WareHouse_Flag"].ToString();
}
if (row["WareHouse_Type"] != null)
{
model.WareHouse_Type = row["WareHouse_Type"].ToString();
}
if (row["WareHouse_Remark"] != null)
{
model.WareHouse_Remark = row["WareHouse_Remark"].ToString();
}
if (row["WareHouse_ID"] != null)
{
model.WareHouse_ID = row["WareHouse_ID"].ToString();
}
if (row["Area_Type"] != null)
{
model.Area_Type = row["Area_Type"].ToString();
}
if (row["Area_Name"] != null)
{
model.Area_Name = row["Area_Name"].ToString();
}
if (row["Area_Code"] != null)
{
model.Area_Code = row["Area_Code"].ToString();
}
if (row["Area_Order"] != null && row["Area_Order"].ToString() != "")
{
model.Area_Order = int.Parse(row["Area_Order"].ToString());
}
if (row["Area_Flag"] != null)
{
model.Area_Flag = row["Area_Flag"].ToString();
}
if (row["Area_BackColor"] != null)
{
model.Area_BackColor = row["Area_BackColor"].ToString();
}
if (row["Area_ID"] != null)
{
model.Area_ID = row["Area_ID"].ToString();
}
if (row["Cell_Code"] != null)
{
model.Cell_Code = row["Cell_Code"].ToString();
}
if (row["Cell_Name"] != null)
{
model.Cell_Name = row["Cell_Name"].ToString();
}
if (row["Cell_Lane"] != null)
{
model.Cell_Lane = row["Cell_Lane"].ToString();
}
if (row["Device_Code"] != null)
{
model.Device_Code = row["Device_Code"].ToString();
}
if (row["Shelf_Type"] != null)
{
model.Shelf_Type = row["Shelf_Type"].ToString();
}
if (row["Cell_InOut"] != null)
{
model.Cell_InOut = row["Cell_InOut"].ToString();
}
if (row["Cell_Type"] != null)
{
model.Cell_Type = row["Cell_Type"].ToString();
}
if (row["Cell_Storage_Type"] != null)
{
model.Cell_Storage_Type = row["Cell_Storage_Type"].ToString();
}
if (row["Cell_Fork_Type"] != null)
{
model.Cell_Fork_Type = row["Cell_Fork_Type"].ToString();
}
if (row["Cell_Layer"] != null && row["Cell_Layer"].ToString() != "")
{
model.Cell_Layer = int.Parse(row["Cell_Layer"].ToString());
}
if (row["Cell_Column"] != null && row["Cell_Column"].ToString() != "")
{
model.Cell_Column = int.Parse(row["Cell_Column"].ToString());
}
if (row["Cell_Row"] != null && row["Cell_Row"].ToString() != "")
{
model.Cell_Row = int.Parse(row["Cell_Row"].ToString());
}
if (row["Cell_Chlid_ID"] != null)
{
model.Cell_Chlid_ID = row["Cell_Chlid_ID"].ToString();
}
if (row["Cell_Chlid_Position"] != null)
{
model.Cell_Chlid_Position = row["Cell_Chlid_Position"].ToString();
}
if (row["Cell_ID"] != null)
{
model.Cell_ID = row["Cell_ID"].ToString();
}
if (row["Cell_Child_Order"] != null && row["Cell_Child_Order"].ToString() != "")
{
model.Cell_Child_Order = int.Parse(row["Cell_Child_Order"].ToString());
}
if (row["Cell_Child_InOut"] != null)
{
model.Cell_Child_InOut = row["Cell_Child_InOut"].ToString();
}
if (row["Cell_Child_Model"] != null)
{
model.Cell_Child_Model = row["Cell_Child_Model"].ToString();
}
if (row["Cell_Child_Status"] != null)
{
model.Cell_Child_Status = row["Cell_Child_Status"].ToString();
}
if (row["Cell_Child_Run_Status"] != null)
{
model.Cell_Child_Run_Status = row["Cell_Child_Run_Status"].ToString();
}
if (row["Cell_Child_Operate_Type"] != null)
{
model.Cell_Child_Operate_Type = row["Cell_Child_Operate_Type"].ToString();
}
if (row["Cell_Child_TaskLock_ID"] != null)
{
model.Cell_Child_TaskLock_ID = row["Cell_Child_TaskLock_ID"].ToString();
}
if (row["Cell_Child_Flag"] != null)
{
model.Cell_Child_Flag = row["Cell_Child_Flag"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WMS_Database.View_CellModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update View_Cell set ");
strSql.Append("WareHouse_Code=@WareHouse_Code,");
strSql.Append("WareHouse_Name=@WareHouse_Name,");
strSql.Append("WareHouse_Flag=@WareHouse_Flag,");
strSql.Append("WareHouse_Type=@WareHouse_Type,");
strSql.Append("WareHouse_Remark=@WareHouse_Remark,");
strSql.Append("WareHouse_ID=@WareHouse_ID,");
strSql.Append("Area_Type=@Area_Type,");
strSql.Append("Area_Name=@Area_Name,");
strSql.Append("Area_Code=@Area_Code,");
strSql.Append("Area_Order=@Area_Order,");
strSql.Append("Area_Flag=@Area_Flag,");
strSql.Append("Area_BackColor=@Area_BackColor,");
strSql.Append("Area_ID=@Area_ID,");
strSql.Append("Cell_Code=@Cell_Code,");
strSql.Append("Cell_Name=@Cell_Name,");
strSql.Append("Cell_Lane=@Cell_Lane,");
strSql.Append("Device_Code=@Device_Code,");
strSql.Append("Shelf_Type=@Shelf_Type,");
strSql.Append("Cell_InOut=@Cell_InOut,");
strSql.Append("Cell_Type=@Cell_Type,");
strSql.Append("Cell_Storage_Type=@Cell_Storage_Type,");
strSql.Append("Cell_Fork_Type=@Cell_Fork_Type,");
strSql.Append("Cell_Layer=@Cell_Layer,");
strSql.Append("Cell_Column=@Cell_Column,");
strSql.Append("Cell_Row=@Cell_Row,");
strSql.Append("Cell_Chlid_ID=@Cell_Chlid_ID,");
strSql.Append("Cell_Chlid_Position=@Cell_Chlid_Position,");
strSql.Append("Cell_ID=@Cell_ID,");
strSql.Append("Cell_Child_Order=@Cell_Child_Order,");
strSql.Append("Cell_Child_InOut=@Cell_Child_InOut,");
strSql.Append("Cell_Child_Model=@Cell_Child_Model,");
strSql.Append("Cell_Child_Status=@Cell_Child_Status,");
strSql.Append("Cell_Child_Run_Status=@Cell_Child_Run_Status,");
strSql.Append("Cell_Child_Operate_Type=@Cell_Child_Operate_Type,");
strSql.Append("Cell_Child_TaskLock_ID=@Cell_Child_TaskLock_ID,");
strSql.Append("Cell_Child_Flag=@Cell_Child_Flag");
strSql.Append(" where WareHouse_Code=@WareHouse_Code and WareHouse_Name=@WareHouse_Name and WareHouse_Flag=@WareHouse_Flag and WareHouse_Type=@WareHouse_Type and WareHouse_Remark=@WareHouse_Remark and WareHouse_ID=@WareHouse_ID and Area_Type=@Area_Type and Area_Name=@Area_Name and Area_Code=@Area_Code and Area_Order=@Area_Order and Area_Flag=@Area_Flag and Area_BackColor=@Area_BackColor and Area_ID=@Area_ID and Cell_Code=@Cell_Code and Cell_Name=@Cell_Name and Cell_Lane=@Cell_Lane and Device_Code=@Device_Code and Shelf_Type=@Shelf_Type and Cell_InOut=@Cell_InOut and Cell_Type=@Cell_Type and Cell_Storage_Type=@Cell_Storage_Type and Cell_Fork_Type=@Cell_Fork_Type and Cell_Layer=@Cell_Layer and Cell_Column=@Cell_Column and Cell_Row=@Cell_Row and Cell_Chlid_ID=@Cell_Chlid_ID and Cell_Chlid_Position=@Cell_Chlid_Position and Cell_ID=@Cell_ID and Cell_Child_Order=@Cell_Child_Order and Cell_Child_InOut=@Cell_Child_InOut and Cell_Child_Model=@Cell_Child_Model and Cell_Child_Status=@Cell_Child_Status and Cell_Child_Run_Status=@Cell_Child_Run_Status and Cell_Child_Operate_Type=@Cell_Child_Operate_Type and Cell_Child_TaskLock_ID=@Cell_Child_TaskLock_ID and Cell_Child_Flag=@Cell_Child_Flag ");
SqlParameter[] parameters =
{
new SqlParameter("@WareHouse_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Flag", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Order", SqlDbType.Int, 4),
new SqlParameter("@Area_Flag", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_BackColor", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Lane", SqlDbType.NVarChar, 50),
new SqlParameter("@Device_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Shelf_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_InOut", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Storage_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Fork_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Layer", SqlDbType.Int, 4),
new SqlParameter("@Cell_Column", SqlDbType.Int, 4),
new SqlParameter("@Cell_Row", SqlDbType.Int, 4),
new SqlParameter("@Cell_Chlid_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Chlid_Position", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Order", SqlDbType.Int, 4),
new SqlParameter("@Cell_Child_InOut", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Model", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Run_Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Operate_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_TaskLock_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Flag", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.WareHouse_Code;
parameters[1].Value = model.WareHouse_Name;
parameters[2].Value = model.WareHouse_Flag;
parameters[3].Value = model.WareHouse_Type;
parameters[4].Value = model.WareHouse_Remark;
parameters[5].Value = model.WareHouse_ID;
parameters[6].Value = model.Area_Type;
parameters[7].Value = model.Area_Name;
parameters[8].Value = model.Area_Code;
parameters[9].Value = model.Area_Order;
parameters[10].Value = model.Area_Flag;
parameters[11].Value = model.Area_BackColor;
parameters[12].Value = model.Area_ID;
parameters[13].Value = model.Cell_Code;
parameters[14].Value = model.Cell_Name;
parameters[15].Value = model.Cell_Lane;
parameters[16].Value = model.Device_Code;
parameters[17].Value = model.Shelf_Type;
parameters[18].Value = model.Cell_InOut;
parameters[19].Value = model.Cell_Type;
parameters[20].Value = model.Cell_Storage_Type;
parameters[21].Value = model.Cell_Fork_Type;
parameters[22].Value = model.Cell_Layer;
parameters[23].Value = model.Cell_Column;
parameters[24].Value = model.Cell_Row;
parameters[25].Value = model.Cell_Chlid_ID;
parameters[26].Value = model.Cell_Chlid_Position;
parameters[27].Value = model.Cell_ID;
parameters[28].Value = model.Cell_Child_Order;
parameters[29].Value = model.Cell_Child_InOut;
parameters[30].Value = model.Cell_Child_Model;
parameters[31].Value = model.Cell_Child_Status;
parameters[32].Value = model.Cell_Child_Run_Status;
parameters[33].Value = model.Cell_Child_Operate_Type;
parameters[34].Value = model.Cell_Child_TaskLock_ID;
parameters[35].Value = model.Cell_Child_Flag;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WMS_Database.View_CellModel GetModel(string WareHouse_Code, string WareHouse_Name, string WareHouse_Flag, string WareHouse_Type, string WareHouse_Remark, string WareHouse_ID, string Area_Type, string Area_Name, string Area_Code, int Area_Order, string Area_Flag, string Area_BackColor, string Area_ID, string Cell_Code, string Cell_Name, string Cell_Lane, string Device_Code, string Shelf_Type, string Cell_InOut, string Cell_Type, string Cell_Storage_Type, string Cell_Fork_Type, int Cell_Layer, int Cell_Column, int Cell_Row, string Cell_Chlid_ID, string Cell_Chlid_Position, string Cell_ID, int Cell_Child_Order, string Cell_Child_InOut, string Cell_Child_Model, string Cell_Child_Status, string Cell_Child_Run_Status, string Cell_Child_Operate_Type, string Cell_Child_TaskLock_ID, string Cell_Child_Flag)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 WareHouse_Code,WareHouse_Name,WareHouse_Flag,WareHouse_Type,WareHouse_Remark,WareHouse_ID,Area_Type,Area_Name,Area_Code,Area_Order,Area_Flag,Area_BackColor,Area_ID,Cell_Code,Cell_Name,Cell_Lane,Device_Code,Shelf_Type,Cell_InOut,Cell_Type,Cell_Storage_Type,Cell_Fork_Type,Cell_Layer,Cell_Column,Cell_Row,Cell_Chlid_ID,Cell_Chlid_Position,Cell_ID,Cell_Child_Order,Cell_Child_InOut,Cell_Child_Model,Cell_Child_Status,Cell_Child_Run_Status,Cell_Child_Operate_Type,Cell_Child_TaskLock_ID,Cell_Child_Flag from View_Cell ");
strSql.Append(" where WareHouse_Code=@WareHouse_Code and WareHouse_Name=@WareHouse_Name and WareHouse_Flag=@WareHouse_Flag and WareHouse_Type=@WareHouse_Type and WareHouse_Remark=@WareHouse_Remark and WareHouse_ID=@WareHouse_ID and Area_Type=@Area_Type and Area_Name=@Area_Name and Area_Code=@Area_Code and Area_Order=@Area_Order and Area_Flag=@Area_Flag and Area_BackColor=@Area_BackColor and Area_ID=@Area_ID and Cell_Code=@Cell_Code and Cell_Name=@Cell_Name and Cell_Lane=@Cell_Lane and Device_Code=@Device_Code and Shelf_Type=@Shelf_Type and Cell_InOut=@Cell_InOut and Cell_Type=@Cell_Type and Cell_Storage_Type=@Cell_Storage_Type and Cell_Fork_Type=@Cell_Fork_Type and Cell_Layer=@Cell_Layer and Cell_Column=@Cell_Column and Cell_Row=@Cell_Row and Cell_Chlid_ID=@Cell_Chlid_ID and Cell_Chlid_Position=@Cell_Chlid_Position and Cell_ID=@Cell_ID and Cell_Child_Order=@Cell_Child_Order and Cell_Child_InOut=@Cell_Child_InOut and Cell_Child_Model=@Cell_Child_Model and Cell_Child_Status=@Cell_Child_Status and Cell_Child_Run_Status=@Cell_Child_Run_Status and Cell_Child_Operate_Type=@Cell_Child_Operate_Type and Cell_Child_TaskLock_ID=@Cell_Child_TaskLock_ID and Cell_Child_Flag=@Cell_Child_Flag ");
SqlParameter[] parameters =
{
new SqlParameter("@WareHouse_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Flag", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Order", SqlDbType.Int, 4),
new SqlParameter("@Area_Flag", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_BackColor", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Lane", SqlDbType.NVarChar, 50),
new SqlParameter("@Device_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Shelf_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_InOut", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Storage_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Fork_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Layer", SqlDbType.Int, 4),
new SqlParameter("@Cell_Column", SqlDbType.Int, 4),
new SqlParameter("@Cell_Row", SqlDbType.Int, 4),
new SqlParameter("@Cell_Chlid_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Chlid_Position", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Order", SqlDbType.Int, 4),
new SqlParameter("@Cell_Child_InOut", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Model", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Run_Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Operate_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_TaskLock_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Flag", SqlDbType.NVarChar, 50)
};
parameters[0].Value = WareHouse_Code;
parameters[1].Value = WareHouse_Name;
parameters[2].Value = WareHouse_Flag;
parameters[3].Value = WareHouse_Type;
parameters[4].Value = WareHouse_Remark;
parameters[5].Value = WareHouse_ID;
parameters[6].Value = Area_Type;
parameters[7].Value = Area_Name;
parameters[8].Value = Area_Code;
parameters[9].Value = Area_Order;
parameters[10].Value = Area_Flag;
parameters[11].Value = Area_BackColor;
parameters[12].Value = Area_ID;
parameters[13].Value = Cell_Code;
parameters[14].Value = Cell_Name;
parameters[15].Value = Cell_Lane;
parameters[16].Value = Device_Code;
parameters[17].Value = Shelf_Type;
parameters[18].Value = Cell_InOut;
parameters[19].Value = Cell_Type;
parameters[20].Value = Cell_Storage_Type;
parameters[21].Value = Cell_Fork_Type;
parameters[22].Value = Cell_Layer;
parameters[23].Value = Cell_Column;
parameters[24].Value = Cell_Row;
parameters[25].Value = Cell_Chlid_ID;
parameters[26].Value = Cell_Chlid_Position;
parameters[27].Value = Cell_ID;
parameters[28].Value = Cell_Child_Order;
parameters[29].Value = Cell_Child_InOut;
parameters[30].Value = Cell_Child_Model;
parameters[31].Value = Cell_Child_Status;
parameters[32].Value = Cell_Child_Run_Status;
parameters[33].Value = Cell_Child_Operate_Type;
parameters[34].Value = Cell_Child_TaskLock_ID;
parameters[35].Value = Cell_Child_Flag;
WMS_Database.View_CellModel model = new WMS_Database.View_CellModel();
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 bool Add(WMS_Database.View_CellModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into View_Cell(");
strSql.Append("WareHouse_Code,WareHouse_Name,WareHouse_Flag,WareHouse_Type,WareHouse_Remark,WareHouse_ID,Area_Type,Area_Name,Area_Code,Area_Order,Area_Flag,Area_BackColor,Area_ID,Cell_Code,Cell_Name,Cell_Lane,Device_Code,Shelf_Type,Cell_InOut,Cell_Type,Cell_Storage_Type,Cell_Fork_Type,Cell_Layer,Cell_Column,Cell_Row,Cell_Chlid_ID,Cell_Chlid_Position,Cell_ID,Cell_Child_Order,Cell_Child_InOut,Cell_Child_Model,Cell_Child_Status,Cell_Child_Run_Status,Cell_Child_Operate_Type,Cell_Child_TaskLock_ID,Cell_Child_Flag)");
strSql.Append(" values (");
strSql.Append("@WareHouse_Code,@WareHouse_Name,@WareHouse_Flag,@WareHouse_Type,@WareHouse_Remark,@WareHouse_ID,@Area_Type,@Area_Name,@Area_Code,@Area_Order,@Area_Flag,@Area_BackColor,@Area_ID,@Cell_Code,@Cell_Name,@Cell_Lane,@Device_Code,@Shelf_Type,@Cell_InOut,@Cell_Type,@Cell_Storage_Type,@Cell_Fork_Type,@Cell_Layer,@Cell_Column,@Cell_Row,@Cell_Chlid_ID,@Cell_Chlid_Position,@Cell_ID,@Cell_Child_Order,@Cell_Child_InOut,@Cell_Child_Model,@Cell_Child_Status,@Cell_Child_Run_Status,@Cell_Child_Operate_Type,@Cell_Child_TaskLock_ID,@Cell_Child_Flag)");
SqlParameter[] parameters =
{
new SqlParameter("@WareHouse_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Flag", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@WareHouse_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_Order", SqlDbType.Int, 4),
new SqlParameter("@Area_Flag", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_BackColor", SqlDbType.NVarChar, 50),
new SqlParameter("@Area_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Lane", SqlDbType.NVarChar, 50),
new SqlParameter("@Device_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Shelf_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_InOut", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Storage_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Fork_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Layer", SqlDbType.Int, 4),
new SqlParameter("@Cell_Column", SqlDbType.Int, 4),
new SqlParameter("@Cell_Row", SqlDbType.Int, 4),
new SqlParameter("@Cell_Chlid_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Chlid_Position", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Order", SqlDbType.Int, 4),
new SqlParameter("@Cell_Child_InOut", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Model", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Run_Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Operate_Type", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_TaskLock_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Cell_Child_Flag", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.WareHouse_Code;
parameters[1].Value = model.WareHouse_Name;
parameters[2].Value = model.WareHouse_Flag;
parameters[3].Value = model.WareHouse_Type;
parameters[4].Value = model.WareHouse_Remark;
parameters[5].Value = model.WareHouse_ID;
parameters[6].Value = model.Area_Type;
parameters[7].Value = model.Area_Name;
parameters[8].Value = model.Area_Code;
parameters[9].Value = model.Area_Order;
parameters[10].Value = model.Area_Flag;
parameters[11].Value = model.Area_BackColor;
parameters[12].Value = model.Area_ID;
parameters[13].Value = model.Cell_Code;
parameters[14].Value = model.Cell_Name;
parameters[15].Value = model.Cell_Lane;
parameters[16].Value = model.Device_Code;
parameters[17].Value = model.Shelf_Type;
parameters[18].Value = model.Cell_InOut;
parameters[19].Value = model.Cell_Type;
parameters[20].Value = model.Cell_Storage_Type;
parameters[21].Value = model.Cell_Fork_Type;
parameters[22].Value = model.Cell_Layer;
parameters[23].Value = model.Cell_Column;
parameters[24].Value = model.Cell_Row;
parameters[25].Value = model.Cell_Chlid_ID;
parameters[26].Value = model.Cell_Chlid_Position;
parameters[27].Value = model.Cell_ID;
parameters[28].Value = model.Cell_Child_Order;
parameters[29].Value = model.Cell_Child_InOut;
parameters[30].Value = model.Cell_Child_Model;
parameters[31].Value = model.Cell_Child_Status;
parameters[32].Value = model.Cell_Child_Run_Status;
parameters[33].Value = model.Cell_Child_Operate_Type;
parameters[34].Value = model.Cell_Child_TaskLock_ID;
parameters[35].Value = model.Cell_Child_Flag;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
