invoicedal.cs

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

           List<Model.Invoice.InvoiceModel> li = new List<Model.Invoice.InvoiceModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Invoice.InvoiceModel inf = new Model.Invoice.InvoiceModel();
               inf.invoice_list_product_id = dr["invoice_list_product_id"].ToString();
               inf.invoice_list_color = dr["invoice_list_color"].ToString();
               inf.invoice_lis_size1 = (int)dr["invoice_lis_size1"];
               inf.invoice_lis_size2 = (int)dr["invoice_lis_size2"];
               inf.invoice_lis_size3 = (int)dr["invoice_lis_size3"];
               inf.invoice_lis_size4 = (int)dr["invoice_lis_size4"];
               inf.invoice_lis_size5 = (int)dr["invoice_lis_size5"];
               inf.invoice_lis_size6 = (int)dr["invoice_lis_size6"];
               inf.invoice_lis_size7 = (int)dr["invoice_lis_size7"];
               inf.invoice_lis_sum = (int)dr["invoice_lis_sum"];
               inf.invoice_store = (int)dr["invoice_store"];
               inf.invoice_storeto = (int)dr["invoice_storeto"];
               li.Add(inf);
           }
           return li;
       }
       /// <summary>
       /// 通过单据ID，获取单据不重复的商品ID
       /// </summary>
       /// <param name="invoice_id"></param>
       /// <returns></returns>
       public List<Model.Invoice.InvoiceModel> InvoiceSelectListPid(string invoice_id)
       {
           string commandtext = "InvoiceSelectListPid";
           SqlParameter xinvoice_id = new SqlParameter("@invoice_id", SqlDbType.Char, 20);
           xinvoice_id.Value = invoice_id;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xinvoice_id });
           List<Model.Invoice.InvoiceModel> li = new List<Model.Invoice.InvoiceModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Invoice.InvoiceModel inf = new Model.Invoice.InvoiceModel();
               inf.invoice_list_product_id = dr["invoice_list_product_id"].ToString();
               li.Add(inf);
           }
           return li;
       }
       /// <summary>
       /// 修改审核总部发（退）货单据
       /// </summary>
       /// <param name="invoice_id"></param>
       /// <param name="Employee_NameCheck"></param>
       /// <param name="invoice_advice"></param>
       /// <param name="invoice_state"></param>
       /// <returns></returns>
       public int UpInvoice(string invoice_id, string Employee_NameCheck, string invoice_advice, string invoice_state)
       {
           string commandtext = "UpInvoice";
           SqlParameter xinvoice_id = new SqlParameter("@invoice_id",SqlDbType.Char,20);
           SqlParameter xEmployee_NameCheck = new SqlParameter("@Employee_NameCheck",SqlDbType.Char,10);
           SqlParameter xinvoice_advice = new SqlParameter("@invoice_advice",SqlDbType.Text);
           SqlParameter xinvoice_state = new SqlParameter("@invoice_state",SqlDbType.VarChar,10);
           xinvoice_id.Value = invoice_id;
           xEmployee_NameCheck.Value = Employee_NameCheck;
           xinvoice_advice.Value = invoice_advice;
           xinvoice_state.Value = invoice_state;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { xinvoice_id, xEmployee_NameCheck, xinvoice_advice, xinvoice_state });
       }


       #region 发货单据信息
       /// <summary>
       ///发货单据信息
       /// </summary>
       /// <returns></returns>
       public List<Model.Invoice.InvoiceModel> InvoiceSelectByWhere()
       {
           List<Model.Invoice.InvoiceModel> li = new List<Model.Invoice.InvoiceModel>();
           string commandtext = "Invoice_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.Invoice.InvoiceModel inf = new Model.Invoice.InvoiceModel();
               inf.invoice_id = item["invoice_id"].ToString().Trim();
               inf.invoice_type_name = item["invoice_type_name"].ToString().Trim();
               inf.Employee_Name = item["Employee_Name"].ToString().Trim();
               inf.Employee_NameCheck = item["Employee_NameCheck"].ToString();
               inf.invoice_time = (DateTime)item["invoice_time"];
               inf.invoice_state = item["invoice_state"].ToString().Trim();
               inf.invoice_allsum = (int)item["invoice_allsum"];
               li.Add(inf);
           }
           return li;
       }
       #endregion

       #region 发货单据明细
       /// <summary>
       ///发货单据明细
       /// </summary>
       /// <returns></returns>
       public List<Model.Invoice.InvoiceModel> InvoiceSetailSelectByWhere()
       {
           List<Model.Invoice.InvoiceModel> li = new List<Model.Invoice.InvoiceModel>();
           string commandtext = "InvoiceSetail_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.Invoice.InvoiceModel inf = new Model.Invoice.InvoiceModel();
               inf.invoice_id = item["invoice_id"].ToString().Trim();
               inf.invoice_list_product_id = item["invoice_list_product_id"].ToString().Trim();
               inf.invoice_list_color = item["invoice_list_color"].ToString().Trim();
               inf.invoice_lis_size1 = (int)item["invoice_lis_size1"];
               inf.invoice_lis_size2 = (int)item["invoice_lis_size2"];
               inf.invoice_lis_size3 = (int)item["invoice_lis_size3"];
               inf.invoice_lis_size4 = (int)item["invoice_lis_size4"];
               inf.invoice_lis_size5 = (int)item["invoice_lis_size5"];
               inf.invoice_lis_size6 = (int)item["invoice_lis_size6"];
               inf.invoice_lis_size7 = (int)item["invoice_lis_size7"];
               inf.invoice_lis_sum = (int)item["invoice_lis_sum"];
               inf.invoice_store = (int)item["invoice_store"];
               inf.invoice_storeto = (int)item["invoice_storeto"];
               li.Add(inf);
           }
           return li;
       }
       #endregion

       #region 通过发货时间获取单据ID
       /// <summary>
       /// 通过发货时间获取单据ID
       /// </summary>
       /// <returns>返回发货据编号的数据集</returns>
       public List<Model.Invoice .InvoiceModel> SelectInvoiceIDByTime(DateTime stocktime)
       {
           string commandtext = "InvoiceID_Select";
           SqlParameter time = new SqlParameter("@invoice_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.Invoice.InvoiceModel> li = new List<Model.Invoice.InvoiceModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Invoice.InvoiceModel inf = new Model.Invoice.InvoiceModel();
               inf.invoice_id = dr["invoice_id"].ToString();
               li.Add(inf);
           }
           return li;
       }
       #endregion

       #region 通过发货单据编号删除调拨明细
       /// <summary>
       /// 通过发货单据编号删除调拨明细
       /// </summary>
       /// <param name="invoiceid">发货单据编号</param>
       /// <returns>返回删除发货单据影响的行数</returns>
       public int InvoiceSetailDelete(string invoiceid)
       {
           string com = "InvoiceSetail_Delete";
           SqlParameter id = new SqlParameter("@invoice_id", SqlDbType.VarChar, 20);
           id.Value = invoiceid;
           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 InvoiceDelete(string invoiceid, string invoicestate)
       {
           string com = "Invoice_Delete";
           SqlParameter id = new SqlParameter("@invoice_id", SqlDbType.VarChar, 20);
           SqlParameter state = new SqlParameter("@invoice_state", SqlDbType.VarChar, 10);
           id.Value = invoiceid;
           state.Value = invoicestate;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id, state });
       }
       #endregion
    }
}