/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Binning GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SLOT_ID,SLOT_INDEX,CAPACITY,PART_ID,SAPCODE,DESCRIPTION,BATCH_NO,STATUS,START_WEIGHT,CURRENT_WEIGHT,THAWING_DATETIME,READY_DATETIME,EXPIRY_DATETIME,MF_EXPIRY_DATE,USER_ID,USER_NAME,USER_GROUP,DEPARTMENT,UPDATED_TIME from Binning ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Model.Binning model = new Model.Binning();
DataTable dt = Common.DB.SqlDB.Query(strSql.ToString(), parameters);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
else
{
return(DataRowToModel(dt.Rows[0]));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Binning model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.Binning model)
{
return(dal.Add(model));
}
public Model.Binning DataRowToModel(DataRow dr)
{
if (dr == null)
{
return(null);
}
Model.Binning model = new Model.Binning();
if (dr["SLOT_ID"].ToString() != "" || dr["SLOT_ID"] != null)
{
model.SLOT_ID = int.Parse(dr["SLOT_ID"].ToString());
}
if (dr["SLOT_INDEX"].ToString() != "" || dr["SLOT_INDEX"] != null)
{
model.SLOT_INDEX = int.Parse(dr["SLOT_INDEX"].ToString());
}
if (dr["CAPACITY"].ToString() != "" || dr["CAPACITY"] != null)
{
model.CAPACITY = int.Parse(dr["CAPACITY"].ToString());
}
model.PART_ID = dr["PART_ID"].ToString();
model.SAPCODE = dr["SAPCODE"].ToString();
model.DESCRIPTION = dr["DESCRIPTION"].ToString();
model.BATCH_NO = dr["BATCH_NO"].ToString();
model.STATUS = dr["STATUS"].ToString();
if (dr["START_WEIGHT"].ToString() != "" || dr["START_WEIGHT"] != null)
{
model.START_WEIGHT = decimal.Parse(dr["START_WEIGHT"].ToString());
}
if (dr["CURRENT_WEIGHT"].ToString() != "" || dr["CURRENT_WEIGHT"] != null)
{
model.CURRENT_WEIGHT = decimal.Parse(dr["CURRENT_WEIGHT"].ToString());
}
if (dr["THAWING_DATETIME"].ToString() != "" || dr["THAWING_DATETIME"] != null)
{
model.THAWING_DATETIME = DateTime.Parse(dr["THAWING_DATETIME"].ToString());
}
if (dr["READY_DATETIME"].ToString() != "" || dr["READY_DATETIME"] != null)
{
model.READY_DATETIME = DateTime.Parse(dr["READY_DATETIME"].ToString());
}
if (dr["EXPIRY_DATETIME"].ToString() != "" || dr["EXPIRY_DATETIME"] != null)
{
model.EXPIRY_DATETIME = DateTime.Parse(dr["EXPIRY_DATETIME"].ToString());
}
if (dr["MF_EXPIRY_DATE"].ToString() != "" || dr["MF_EXPIRY_DATE"] != null)
{
model.MF_EXPIRY_DATE = DateTime.Parse(dr["MF_EXPIRY_DATE"].ToString());
}
model.USER_ID = dr["USER_ID"].ToString();
model.USER_NAME = dr["USER_NAME"].ToString();
model.USER_GROUP = dr["USER_GROUP"].ToString();
model.DEPARTMENT = dr["DEPARTMENT"].ToString();
if (dr["UPDATED_TIME"].ToString() != "" || dr["UPDATED_TIME"] != null)
{
model.UPDATED_TIME = DateTime.Parse(dr["UPDATED_TIME"].ToString());
}
return(model);
}
public SqlCommand UpdateCommand(Model.Binning model)
{
return(dal.UpdateCommand(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.Binning model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Binning(");
strSql.Append("SLOT_ID,SLOT_INDEX,CAPACITY,PART_ID,SAPCODE,DESCRIPTION,BATCH_NO,STATUS,START_WEIGHT,CURRENT_WEIGHT,THAWING_DATETIME,READY_DATETIME,EXPIRY_DATETIME,MF_EXPIRY_DATE,USER_ID,USER_NAME,USER_GROUP,DEPARTMENT,UPDATED_TIME)");
strSql.Append(" values (");
strSql.Append("@SLOT_ID,@SLOT_INDEX,@CAPACITY,@PART_ID,@SAPCODE,@DESCRIPTION,@BATCH_NO,@STATUS,@START_WEIGHT,@CURRENT_WEIGHT,@THAWING_DATETIME,@READY_DATETIME,@EXPIRY_DATETIME,@MF_EXPIRY_DATE,@USER_ID,@USER_NAME,@USER_GROUP,@DEPARTMENT,@UPDATED_TIME)");
SqlParameter[] parameters =
{
new SqlParameter("@SLOT_ID", SqlDbType.Int, 4),
new SqlParameter("@SLOT_INDEX", SqlDbType.Int, 4),
new SqlParameter("@CAPACITY", SqlDbType.Int, 4),
new SqlParameter("@PART_ID", SqlDbType.VarChar, 50),
new SqlParameter("@SAPCODE", SqlDbType.VarChar, 50),
new SqlParameter("@DESCRIPTION", SqlDbType.VarChar, 50),
new SqlParameter("@BATCH_NO", SqlDbType.VarChar, 50),
new SqlParameter("@STATUS", SqlDbType.VarChar, 50),
new SqlParameter("@START_WEIGHT", SqlDbType.Decimal, 5),
new SqlParameter("@CURRENT_WEIGHT", SqlDbType.Decimal, 5),
new SqlParameter("@THAWING_DATETIME", SqlDbType.DateTime),
new SqlParameter("@READY_DATETIME", SqlDbType.DateTime),
new SqlParameter("@EXPIRY_DATETIME", SqlDbType.DateTime),
new SqlParameter("@MF_EXPIRY_DATE", SqlDbType.DateTime),
new SqlParameter("@USER_ID", SqlDbType.VarChar, 50),
new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50),
new SqlParameter("@USER_GROUP", SqlDbType.VarChar, 50),
new SqlParameter("@DEPARTMENT", SqlDbType.VarChar, 50),
new SqlParameter("@UPDATED_TIME", SqlDbType.DateTime)
};
parameters[0].Value = model.SLOT_ID;
parameters[1].Value = model.SLOT_INDEX;
parameters[2].Value = model.CAPACITY;
parameters[3].Value = model.PART_ID;
parameters[4].Value = model.SAPCODE;
parameters[5].Value = model.DESCRIPTION;
parameters[6].Value = model.BATCH_NO;
parameters[7].Value = model.STATUS;
parameters[8].Value = model.START_WEIGHT;
parameters[9].Value = model.CURRENT_WEIGHT;
parameters[10].Value = model.THAWING_DATETIME;
parameters[11].Value = model.READY_DATETIME;
parameters[12].Value = model.EXPIRY_DATETIME;
parameters[13].Value = model.MF_EXPIRY_DATE;
parameters[14].Value = model.USER_ID;
parameters[15].Value = model.USER_NAME;
parameters[16].Value = model.USER_GROUP;
parameters[17].Value = model.DEPARTMENT;
parameters[18].Value = model.UPDATED_TIME;
int rows = Common.DB.SqlDB.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public SqlCommand UpdateCommand(Model.Binning model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Binning set ");
strSql.Append("SLOT_ID=@SLOT_ID,");
strSql.Append("SLOT_INDEX=@SLOT_INDEX,");
strSql.Append("CAPACITY=@CAPACITY,");
strSql.Append("PART_ID=@PART_ID,");
strSql.Append("SAPCODE=@SAPCODE,");
strSql.Append("DESCRIPTION=@DESCRIPTION,");
strSql.Append("BATCH_NO=@BATCH_NO,");
strSql.Append("STATUS=@STATUS,");
strSql.Append("START_WEIGHT=@START_WEIGHT,");
strSql.Append("CURRENT_WEIGHT=@CURRENT_WEIGHT,");
strSql.Append("THAWING_DATETIME=@THAWING_DATETIME,");
strSql.Append("READY_DATETIME=@READY_DATETIME,");
strSql.Append("EXPIRY_DATETIME=@EXPIRY_DATETIME,");
strSql.Append("MF_EXPIRY_DATE=@MF_EXPIRY_DATE,");
strSql.Append("USER_ID=@USER_ID,");
strSql.Append("USER_NAME=@USER_NAME,");
strSql.Append("USER_GROUP=@USER_GROUP,");
strSql.Append("DEPARTMENT=@DEPARTMENT,");
strSql.Append("UPDATED_TIME=@UPDATED_TIME");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@SLOT_ID", SqlDbType.Int, 4),
new SqlParameter("@SLOT_INDEX", SqlDbType.Int, 4),
new SqlParameter("@CAPACITY", SqlDbType.Int, 4),
new SqlParameter("@PART_ID", SqlDbType.VarChar, 50),
new SqlParameter("@SAPCODE", SqlDbType.VarChar, 50),
new SqlParameter("@DESCRIPTION", SqlDbType.VarChar, 50),
new SqlParameter("@BATCH_NO", SqlDbType.VarChar, 50),
new SqlParameter("@STATUS", SqlDbType.VarChar, 50),
new SqlParameter("@START_WEIGHT", SqlDbType.Decimal, 5),
new SqlParameter("@CURRENT_WEIGHT", SqlDbType.Decimal, 5),
new SqlParameter("@THAWING_DATETIME", SqlDbType.DateTime),
new SqlParameter("@READY_DATETIME", SqlDbType.DateTime),
new SqlParameter("@EXPIRY_DATETIME", SqlDbType.DateTime),
new SqlParameter("@MF_EXPIRY_DATE", SqlDbType.DateTime),
new SqlParameter("@USER_ID", SqlDbType.VarChar, 50),
new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50),
new SqlParameter("@USER_GROUP", SqlDbType.VarChar, 50),
new SqlParameter("@DEPARTMENT", SqlDbType.VarChar, 50),
new SqlParameter("@UPDATED_TIME", SqlDbType.DateTime)
};
parameters[0].Value = model.SLOT_ID;
parameters[1].Value = model.SLOT_INDEX;
parameters[2].Value = model.CAPACITY;
parameters[3].Value = model.PART_ID;
parameters[4].Value = model.SAPCODE;
parameters[5].Value = model.DESCRIPTION;
parameters[6].Value = model.BATCH_NO;
parameters[7].Value = model.STATUS;
parameters[8].Value = model.START_WEIGHT;
parameters[9].Value = model.CURRENT_WEIGHT;
parameters[10].Value = model.THAWING_DATETIME;
parameters[11].Value = model.READY_DATETIME;
parameters[12].Value = model.EXPIRY_DATETIME;
parameters[13].Value = model.MF_EXPIRY_DATE;
parameters[14].Value = model.USER_ID;
parameters[15].Value = model.USER_NAME;
parameters[16].Value = model.USER_GROUP;
parameters[17].Value = model.DEPARTMENT;
parameters[18].Value = model.UPDATED_TIME;
return(Common.DB.SqlDB.GenerateCommand(strSql.ToString(), parameters));
}
