/// <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));
}
