removedal.cs

c#三层架构项目开发的全过程

               mo.remove_list_size5 = (int)item["remove_list_size5"];
               mo.remove_list_size6 = (int)item["remove_list_size6"];
               mo.remove_list_size7 = (int)item["remove_list_size7"];
               mo.remove_list_sum = (int)item["remove_list_sum"];
               li.Add(mo);
           }
           return li;
       }
       /// <summary>
       /// 获得调拨申请单商品ID，不重复（调拨单ID）
       /// </summary>
       /// <param name="remove_id"></param>
       /// <returns></returns>
       public List<Model.Remove.RemoveModel> SelectRemoveListPid(string remove_id)
       {
           string commandtext = "RemoveSelectListPid";
           SqlParameter xremove_id = new SqlParameter("@remove_id", SqlDbType.Char, 20);
           xremove_id.Value = remove_id;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xremove_id });
           List<Model.Remove.RemoveModel> li = new List<Model.Remove.RemoveModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Remove.RemoveModel mo = new Model.Remove.RemoveModel();
               mo.Product_id = item["Product_id"].ToString();
               li.Add(mo);
           }
           return li;
       }
       /// <summary>
       /// 修改单据审核状态
       /// </summary>
       /// <param name="remove_assessor"></param>
       /// <param name="remove_advice"></param>
       /// <param name="remove_state"></param>
       /// <returns></returns>
       public int UpRemove(string remove_id, string remove_assessor, string remove_advice, string remove_state)
       {
           string commandtext = "UpRemove";
           SqlParameter xremove_id = new SqlParameter("@remove_id",SqlDbType.Char,20);
           SqlParameter xremove_assessor = new SqlParameter("@remove_assessor",SqlDbType.VarChar,10);
           SqlParameter xremove_advice = new SqlParameter("@remove_advice",SqlDbType.Text);
           SqlParameter xremove_state = new SqlParameter("@remove_state",SqlDbType.VarChar,10);
           xremove_id.Value = remove_id;
           xremove_assessor.Value = remove_assessor;
           xremove_advice.Value = remove_advice;
           xremove_state.Value = remove_state;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] {xremove_id,xremove_assessor, xremove_advice, xremove_state });
       }


       #region 调拨单据信息
       /// <summary>
       /// 调拨单据信息
       /// </summary>
       /// <returns></returns>
       public List<Model.Remove.RemoveModel> RemoveSelectByWhere()
       {
           List<Model.Remove.RemoveModel> li = new List<Model.Remove.RemoveModel>();
           string commandtext = "Remove_Select";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Remove.RemoveModel inf = new Model.Remove.RemoveModel();
               inf.remove_id = item["remove_id"].ToString().Trim();
               inf.remove_pname = item["remove_pname"].ToString().Trim();
               inf.remove_go = item["remove_go"].ToString().Trim();
               inf.remove_to = item["remove_to"].ToString();
               inf.remove_time = (DateTime)item["remove_time"];
               inf.remove_assessor = item["remove_assessor"].ToString();
               inf.remove_state = item["remove_state"].ToString().Trim();
               inf.remove_allsum = (int)item["remove_allsum"];
               li.Add(inf);
           }
           return li;
       }
       #endregion

       #region 调拨明细
       /// <summary>
       /// 调拨明细
       /// </summary>
       /// <returns></returns>
       public List<Model.Remove.RemoveModel> RemoveSetailSelectByWhere()
       {
           List<Model.Remove.RemoveModel> li = new List<Model.Remove.RemoveModel>();
           string commandtext = "RemoveSetail_Select";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Remove.RemoveModel inf = new Model.Remove.RemoveModel();
               inf.remove_id = item["remove_id"].ToString().Trim();
               inf.Product_id = item["Product_id"].ToString().Trim();
               inf.remove_list_color = item["remove_list_color"].ToString().Trim();
               inf.remove_list_size1 = (int)item["remove_list_size1"];
               inf.remove_list_size2 = (int)item["remove_list_size2"];
               inf.remove_list_size3 = (int)item["remove_list_size3"];
               inf.remove_list_size4 = (int)item["remove_list_size4"];
               inf.remove_list_size5 = (int)item["remove_list_size5"];
               inf.remove_list_size6 = (int)item["remove_list_size6"];
               inf.remove_list_size7 = (int)item["remove_list_size7"];
               inf.remove_list_sum = (int)item["remove_list_sum"];
               inf.remove_go = item["remove_go"].ToString().Trim();
               inf.remove_to = item["remove_to"].ToString().Trim();
               li.Add(inf);
           }
           return li;
       }
       #endregion

       #region 通过调拨时间获取单据ID
       /// <summary>
       /// 通过调拨时间获取单据ID
       /// </summary>
       /// <returns>返回调拨据编号的数据集</returns>
       public List<Model.Remove.RemoveModel> SelectRemoveIDByTime(DateTime stocktime)
       {
           string commandtext = "RemoveID_Select";
           SqlParameter time = new SqlParameter("@remove_time", SqlDbType.DateTime);
           time.Value = stocktime;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { time });
           List<Model.Remove.RemoveModel> li = new List<Model.Remove.RemoveModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Remove.RemoveModel inf = new Model.Remove.RemoveModel();
               inf.remove_id = dr["remove_id"].ToString();
               li.Add(inf);
           }
           return li;
       }
       #endregion

       #region 通过调拨单据编号删除调拨明细
       /// <summary>
       /// 通过调拨单据编号删除调拨明细
       /// </summary>
       /// <param name="removeid">调拨单据编号</param>
       /// <returns>返回删除调拨单据影响的行数</returns>
       public int RemoveSetailDelete(string removeid)
       {
           string com = "RemoveSetail_Delete";
           SqlParameter id = new SqlParameter("@remove_id", SqlDbType.VarChar, 20);
           id.Value = removeid;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id });
       }
       #endregion

       #region 通过调拨单据编号删除调拨单据信息
       /// <summary>
       /// 通过调拨单据编号删除调拨单据信息
       /// </summary>
       /// <param name="removeid">调拨单据编号</param>
       /// <param name="removestate">调拨单据审核状态</param>
       /// <returns>返回删除调拨单据影响的行数</returns>
       public int RemoveDelete(string removeid, string removestate)
       {
           string com = "Remove_Delete";
           SqlParameter id = new SqlParameter("@remove_id", SqlDbType.VarChar, 20);
           SqlParameter state = new SqlParameter("@remove_state",SqlDbType.VarChar,10);
           id.Value = removeid;
           state.Value = removestate;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id, state });
       }
       #endregion
    }
}