/// <summary> /// 保存运输合同 /// </summary> /// <param name="transportContract">运输合同对象</param> /// <param name="list">合同明细集合</param> /// <returns>True:成功,False:失败</returns> public bool saveContract(TransportContract transportContract, List <TransportGoodsInformationCorresponding> list) { ArrayList sqllist = new ArrayList(); sqllist.Add(new transportContractAction().GetInsertSql(transportContract)); foreach (TransportGoodsInformationCorresponding transportGoodsInformationCorresponding in list) { sqllist.Add(new TransportGoodsInformationCorrespondingAction().GetInsertSql(transportGoodsInformationCorresponding)); } return(sqlHelper.ExecuteTransaction(sqllist)); }
private TransportContract getTransportContract() { TransportContract transportContract = new TransportContract(); transportContract.contractEndDate = dtp_contractEndDate.Value; transportContract.contractInkDate = dtp_contractInkDate.Value; transportContract.contractName = txt_name.Text.Trim(); transportContract.contractStartDate = dtp_contractStartDate.Value; transportContract.inputMan = this.UserName; transportContract.remark = txt_remark.Text.Trim(); if (transportLogic.getcType(rbcType1, rbcType2) == 0) { transportContract.no = cmb_no.Text.Trim(); } else { transportContract.no = txt_sno.Text.Trim(); transportContract.ParentId = long.Parse(cmb_no.SelectedValue.ToString()); } transportContract.tuId = long.Parse(cmb_transportUnit.SelectedValue.ToString()); return(transportContract); }
/// <summary> /// 获取增加操作SQL字符串 /// </summary> public string GetInsertSql(TransportContract model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.contractName != null) { strSql1.Append("contractName,"); strSql2.Append("'" + model.contractName + "',"); } if (model.no != null) { strSql1.Append("no,"); strSql2.Append("'" + model.no + "',"); } if (model.tuId != null) { strSql1.Append("tuId,"); strSql2.Append("" + model.tuId + ","); } if (model.contractInkDate != null) { strSql1.Append("contractInkDate,"); strSql2.Append("'" + model.contractInkDate + "',"); } if (model.contractStartDate != null) { strSql1.Append("contractStartDate,"); strSql2.Append("'" + model.contractStartDate + "',"); } if (model.contractEndDate != null) { strSql1.Append("contractEndDate,"); strSql2.Append("'" + model.contractEndDate + "',"); } strSql1.Append("inputDate,"); strSql2.Append("getdate(),"); if (model.inputMan != null) { strSql1.Append("inputMan,"); strSql2.Append("'" + model.inputMan + "',"); } if (model.assessor != null) { strSql1.Append("assessor,"); strSql2.Append("'" + model.assessor + "',"); } if (model.checkupMan != null) { strSql1.Append("checkupMan,"); strSql2.Append("'" + model.checkupMan + "',"); } strSql1.Append("mark,"); strSql2.Append("0,"); if (model.remark != null) { strSql1.Append("remark,"); strSql2.Append("'" + model.remark + "',"); } if (model.ParentId != null) { strSql1.Append("ParentId,"); strSql2.Append("'" + model.ParentId + "',"); } strSql.Append("insert into transportContract("); 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(";declare @pid int;"); strSql.Append("set @pid=@@IDENTITY;"); return(strSql.ToString()); }
/// <summary> /// 保存运输合同 /// </summary> /// <param name="transportContract">运输合同对象</param> /// <param name="list">合同明细集合</param> /// <returns>True:成功,False:失败</returns> public bool saveContract(TransportContract transportContract, List <TransportGoodsInformationCorresponding> list) { return(transportDB.saveContract(transportContract, list)); }