/// <summary> /// 更新一条数据 /// </summary> public void Update(VAN_OA.Model.JXC.TB_SupplierAdvancePayments model, SqlCommand objCommand) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TB_SupplierAdvancePayments set "); //if (model.Id != null) //{ // strSql.Append("Id=" + model.Id + ","); //} //if (model.CaiIds != null) //{ // strSql.Append("CaiIds=" + model.CaiIds + ","); //} if (model.SupplierFPNo != null) { strSql.Append("SupplierFPNo='" + model.SupplierFPNo + "',"); } if (model.SupplierInvoiceDate != null) { strSql.Append("SupplierInvoiceDate='" + model.SupplierInvoiceDate + "',"); } if (model.SupplierInvoiceNum != null) { strSql.Append("SupplierInvoiceNum=" + model.SupplierInvoiceNum + ","); } if (model.SupplierInvoicePrice != null) { strSql.Append("SupplierInvoicePrice=" + model.SupplierInvoicePrice + ","); } if (model.SupplierInvoiceTotal != null) { strSql.Append("SupplierInvoiceTotal=" + model.SupplierInvoiceTotal + ","); } if (model.SupplierProNo != null) { strSql.Append("SupplierProNo='" + model.SupplierProNo + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Ids=" + model.Ids + ""); objCommand.CommandText = strSql.ToString(); objCommand.ExecuteNonQuery(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(VAN_OA.Model.JXC.TB_SupplierAdvancePayments model, SqlCommand objCommand) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.Id != null) { strSql1.Append("Id,"); strSql2.Append("" + model.Id + ","); } if (model.CaiIds != null) { strSql1.Append("CaiIds,"); strSql2.Append("" + model.CaiIds + ","); } if (model.SupplierFPNo != null) { strSql1.Append("SupplierFPNo,"); strSql2.Append("'" + model.SupplierFPNo + "',"); } if (model.SupplierInvoiceDate != null) { strSql1.Append("SupplierInvoiceDate,"); strSql2.Append("'" + model.SupplierInvoiceDate + "',"); } if (model.SupplierInvoiceNum != null) { strSql1.Append("SupplierInvoiceNum,"); strSql2.Append("" + model.SupplierInvoiceNum + ","); } if (model.SupplierInvoicePrice != null) { strSql1.Append("SupplierInvoicePrice,"); strSql2.Append("" + model.SupplierInvoicePrice + ","); } if (model.SupplierInvoiceTotal != null) { strSql1.Append("SupplierInvoiceTotal,"); strSql2.Append("" + model.SupplierInvoiceTotal + ","); } strSql1.Append("SupplierProNo,"); strSql2.Append("'" + model.SupplierProNo + "',"); strSql.Append("insert into TB_SupplierAdvancePayments("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); int result; objCommand.CommandText = strSql.ToString(); object obj = objCommand.ExecuteScalar(); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }