public LendingManager GetGoodsCodeRange_DRToModelDTToList(DataRow dr)
{
LendingManager model = new LendingManager();
if (dr != null)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.nLendingTypeID = ObjectConvertClass.static_ext_int(dr["nLendingTypeID"]);
model.nStartCode = ObjectConvertClass.static_ext_int(dr["nStartCode"]);
model.nStopCode = ObjectConvertClass.static_ext_int(dr["nStopCode"]);
model.strExceptCodes = ObjectConvertClass.static_ext_string(dr["strExceptCodes"]);
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
}
return(model);
}
public bool InsertGoodsCodeRange(LendingManager model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Tab_Base_LendingManager");
strSql.Append("(strGUID,nLendingTypeID,nStartCode,nStopCode,strExceptCodes,strWorkShopGUID)");
strSql.Append("values(@strGUID,@nLendingTypeID,@nStartCode,@nStopCode,@strExceptCodes,@strWorkShopGUID)");
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@strGUID", model.strGUID),
new SqlParameter("@nLendingTypeID", model.nLendingTypeID),
new SqlParameter("@nStartCode", model.nStartCode),
new SqlParameter("@nStopCode", model.nStopCode),
new SqlParameter("@strExceptCodes", model.strExceptCodes),
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParameters) > 0);
}
public bool UpdateGoodsCodeRange(LendingManager model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update Tab_Base_LendingManager set ");
strSql.Append(" nLendingTypeID = @nLendingTypeID, ");
strSql.Append(" nStartCode = @nStartCode, ");
strSql.Append(" nStopCode = @nStopCode, ");
strSql.Append(" strExceptCodes = @strExceptCodes, ");
strSql.Append(" strWorkShopGUID = @strWorkShopGUID ");
strSql.Append(" where strGUID = @strGUID ");
SqlParameter[] parameters =
{
new SqlParameter("@strGUID", model.strGUID),
new SqlParameter("@nLendingTypeID", model.nLendingTypeID),
new SqlParameter("@nStartCode", model.nStartCode),
new SqlParameter("@nStopCode", model.nStopCode),
new SqlParameter("@strExceptCodes", model.strExceptCodes),
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
