public int Update(YHFramework.SysModel.BoxNumberModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BoxNumber set ");
strSql.Append("BoxNumber=@BoxNumber,ShortBoxNumber=@ShortBoxNumber,IndexCode=@IndexCode,BatchNumber=@BatchNumber,ContentStatusId=@ContentStatusId,IsBind=@IsBind,BindTime=@BindTime,UpdateOn=@UpdateOn,CreateOn=@CreateOn,ApployInfoId=@ApployInfoId ");
strSql.Append(" where BoxNumberId=@BoxNumberId ");
SqlParameter[] parameters =
{
new SqlParameter("@BoxNumber", DbTool.FixSqlParameter(model.BoxNumber))
, new SqlParameter("@ShortBoxNumber", DbTool.FixSqlParameter(model.ShortBoxNumber))
, new SqlParameter("@IndexCode", DbTool.FixSqlParameter(model.IndexCode))
, new SqlParameter("@BatchNumber", DbTool.FixSqlParameter(model.BatchNumber))
, new SqlParameter("@ContentStatusId", DbTool.FixSqlParameter(model.ContentStatusId))
, new SqlParameter("@IsBind", DbTool.FixSqlParameter(model.IsBind))
, new SqlParameter("@BindTime", DbTool.FixSqlParameter(model.BindTime))
, new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn))
, new SqlParameter("@CreateOn", DbTool.FixSqlParameter(model.CreateOn))
, new SqlParameter("@ApployInfoId", DbTool.FixSqlParameter(model.ApployInfoId))
, new SqlParameter("@BoxNumberId", model.BoxNumberId)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(YHFramework.SysModel.BoxNumberModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [BoxNumber]");
strSql.Append("(BoxNumber,ShortBoxNumber,IndexCode,BatchNumber,ContentStatusId,IsBind,BindTime,UpdateOn,CreateOn,ApployInfoId)");
strSql.Append(" values (@BoxNumber,@ShortBoxNumber,@IndexCode,@BatchNumber,@ContentStatusId,@IsBind,@BindTime,@UpdateOn,@CreateOn,@ApployInfoId)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@BoxNumber", DbTool.FixSqlParameter(model.BoxNumber))
, new SqlParameter("@ShortBoxNumber", DbTool.FixSqlParameter(model.ShortBoxNumber))
, new SqlParameter("@IndexCode", DbTool.FixSqlParameter(model.IndexCode))
, new SqlParameter("@BatchNumber", DbTool.FixSqlParameter(model.BatchNumber))
, new SqlParameter("@ContentStatusId", DbTool.FixSqlParameter(model.ContentStatusId))
, new SqlParameter("@IsBind", DbTool.FixSqlParameter(model.IsBind))
, new SqlParameter("@BindTime", DbTool.FixSqlParameter(model.BindTime))
, new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn))
, new SqlParameter("@CreateOn", DbTool.FixSqlParameter(model.CreateOn))
, new SqlParameter("@ApployInfoId", DbTool.FixSqlParameter(model.ApployInfoId))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
protected YHFramework.SysModel.BoxNumberModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new YHFramework.SysModel.BoxNumberModel();
if (DbTool.HasFields("BoxNumberId", fields))
{
model.BoxNumberId = DbTool.ConvertObject <System.Int32>(dr["BoxNumberId"]);
}
if (DbTool.HasFields("BoxNumber", fields))
{
model.BoxNumber = DbTool.ConvertObject <System.String>(dr["BoxNumber"]);
}
if (DbTool.HasFields("ShortBoxNumber", fields))
{
model.ShortBoxNumber = DbTool.ConvertObject <System.String>(dr["ShortBoxNumber"]);
}
if (DbTool.HasFields("IndexCode", fields))
{
model.IndexCode = DbTool.ConvertObject <System.String>(dr["IndexCode"]);
}
if (DbTool.HasFields("BatchNumber", fields))
{
model.BatchNumber = DbTool.ConvertObject <System.String>(dr["BatchNumber"]);
}
if (DbTool.HasFields("ContentStatusId", fields))
{
model.ContentStatusId = DbTool.ConvertObject <System.String>(dr["ContentStatusId"]);
}
if (DbTool.HasFields("IsBind", fields))
{
model.IsBind = DbTool.ConvertObject <System.Boolean>(dr["IsBind"]);
}
if (DbTool.HasFields("BindTime", fields))
{
model.BindTime = DbTool.ConvertObject <System.DateTime>(dr["BindTime"]);
}
if (DbTool.HasFields("UpdateOn", fields))
{
model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]);
}
if (DbTool.HasFields("CreateOn", fields))
{
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
}
if (DbTool.HasFields("ApployInfoId", fields))
{
model.ApployInfoId = DbTool.ConvertObject <System.Int32>(dr["ApployInfoId"]);
}
return(model);
}
protected void BindDataReader(YHFramework.SysModel.BoxNumberModel model, SqlDataReader dr)
{
model.BoxNumberId = DbTool.ConvertObject <System.Int32>(dr["BoxNumberId"]);
model.BoxNumber = DbTool.ConvertObject <System.String>(dr["BoxNumber"]);
model.ShortBoxNumber = DbTool.ConvertObject <System.String>(dr["ShortBoxNumber"]);
model.IndexCode = DbTool.ConvertObject <System.String>(dr["IndexCode"]);
model.BatchNumber = DbTool.ConvertObject <System.String>(dr["BatchNumber"]);
model.ContentStatusId = DbTool.ConvertObject <System.String>(dr["ContentStatusId"]);
model.IsBind = DbTool.ConvertObject <System.Boolean>(dr["IsBind"]);
model.BindTime = DbTool.ConvertObject <System.DateTime>(dr["BindTime"]);
model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]);
model.CreateOn = DbTool.ConvertObject <System.DateTime>(dr["CreateOn"]);
model.ApployInfoId = DbTool.ConvertObject <System.Int32>(dr["ApployInfoId"]);
}
public YHFramework.SysModel.BoxNumberModel GetModelByBoxNumber(string boxnumber)
{
string sql = "select top 1 * from BoxNumber where BoxNumber ='" + boxnumber.FixSql() + "'";
YHFramework.SysModel.BoxNumberModel model = new YHFramework.SysModel.BoxNumberModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
//var fields = DbTool.GetReaderFieldNames(dr);
//model = AutoBindDataReader(dr, fields);
BindDataReader(model, dr);
}
dr.Close();
return(model);
}
public List <YHFramework.SysModel.BoxNumberModel> GetModelList()
{
List <YHFramework.SysModel.BoxNumberModel> result = new List <YHFramework.SysModel.BoxNumberModel>();
string sql = "select * from BoxNumber where 1=1";
YHFramework.SysModel.BoxNumberModel model = new YHFramework.SysModel.BoxNumberModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
//var fields = DbTool.GetReaderFieldNames(dr);
while (dr.Read())
{
//model = AutoBindDataReader(dr, fields);
model = new YHFramework.SysModel.BoxNumberModel();
BindDataReader(model, dr);
result.Add(model);
}
dr.Close();
return(result);
}