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); }