/// <summary> ///[to_InvoiceDetial]表查询实体的方法 /// </summary> public static To_InvoiceDetial getTo_InvoiceDetialById(int id) { To_InvoiceDetial to_invoicedetial = null; string sql = "select * from to_InvoiceDetial where id=@id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@id", id) }; DataTable dt = DBHelper.GetDataSet(sql, sp); if (dt.Rows.Count > 0) { to_invoicedetial = new To_InvoiceDetial(); foreach (DataRow dr in dt.Rows) { to_invoicedetial.Id = Convert.ToInt32(dr["id"]); to_invoicedetial.InvoiceID = Convert.ToInt32(dr["invoiceID"]); to_invoicedetial.PolicyID = Convert.ToString(dr["policyID"]); to_invoicedetial.CusName = Convert.ToString(dr["cusName"]); to_invoicedetial.Cost = Convert.ToDouble(dr["cost"]); to_invoicedetial.DetialReamrk = Convert.ToString(dr["detialReamrk"]); } } return(to_invoicedetial); }
//添加详细信息 private void addcombank() { string policyList = this.HidPolicy.Value; if (policyList != "") { string[] row = null; string[] cell = null; EtNet_Models.To_InvoiceDetial invoiceDetial = null; if (policyList.IndexOf(',') >= 0) { row = policyList.Split(','); } else { row = new string[1] { policyList }; } for (int i = 0; i < row.Length; i++) { invoiceDetial = new To_InvoiceDetial(); cell = row[i].Split('|'); invoiceDetial.PolicyID = cell[0]; invoiceDetial.CusName = cell[1]; invoiceDetial.Cost = float.Parse(cell[2]); invoiceDetial.DetialReamrk = ""; invoiceDetial.InvoiceID = To_InvoiceManager.getTo_InvoiceLastONE().Id; To_InvoiceDetialManager.addTo_InvoiceDetial(invoiceDetial); } } }
/// <summary> ///[to_InvoiceDetial]表添加的方法 /// </summary> public static int addTo_InvoiceDetial(To_InvoiceDetial to_invoicedetial) { string sql = "insert into to_InvoiceDetial([invoiceID],[policyID],[cusName],[cost],[detialReamrk]) values (@invoiceID,@policyID,@cusName,@cost,@detialReamrk)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@invoiceID", to_invoicedetial.InvoiceID), new SqlParameter("@policyID", to_invoicedetial.PolicyID), new SqlParameter("@cusName", to_invoicedetial.CusName), new SqlParameter("@cost", to_invoicedetial.Cost), new SqlParameter("@detialReamrk", to_invoicedetial.DetialReamrk) }; return(DBHelper.ExecuteCommand(sql, sp)); }
/// <summary> ///[to_InvoiceDetial]表修改的方法 /// </summary> public static int updateTo_InvoiceDetialById(To_InvoiceDetial to_invoicedetial) { string sql = "update to_InvoiceDetial set invoiceID=@invoiceID,policyID=@policyID,cusName=@cusName,cost=@cost,detialReamrk=@detialReamrk where id=@id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@id", to_invoicedetial.Id), new SqlParameter("@invoiceID", to_invoicedetial.InvoiceID), new SqlParameter("@policyID", to_invoicedetial.PolicyID), new SqlParameter("@cusName", to_invoicedetial.CusName), new SqlParameter("@cost", to_invoicedetial.Cost), new SqlParameter("@detialReamrk", to_invoicedetial.DetialReamrk) }; return(DBHelper.ExecuteCommand(sql, sp)); }
/// <summary> ///根据SQL语句获取实体 /// </summary> public static To_InvoiceDetial getTo_InvoiceDetialBySql(string sql) { To_InvoiceDetial to_invoicedetial = null; DataTable dt = DBHelper.GetDataSet(sql); if (dt.Rows.Count > 0) { to_invoicedetial = new To_InvoiceDetial(); foreach (DataRow dr in dt.Rows) { to_invoicedetial.Id = Convert.ToInt32(dr["id"]); to_invoicedetial.InvoiceID = Convert.ToInt32(dr["invoiceID"]); to_invoicedetial.PolicyID = Convert.ToString(dr["policyID"]); to_invoicedetial.CusName = Convert.ToString(dr["cusName"]); to_invoicedetial.Cost = Convert.ToDouble(dr["cost"]); to_invoicedetial.DetialReamrk = Convert.ToString(dr["detialReamrk"]); } } return(to_invoicedetial); }
public static int addTo_InvoiceDetial(To_InvoiceDetial to_invoicedetial) { return(To_InvoiceDetialService.addTo_InvoiceDetial(to_invoicedetial)); }
public static int updateTo_InvoiceDetial(To_InvoiceDetial to_invoicedetial) { return(To_InvoiceDetialService.updateTo_InvoiceDetialById(to_invoicedetial)); }