public bool AddCallBidsCrop(BidCorpModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" insert into OPM_CallBids_BidCorp(UID,CorpID,CallBidID,ConstructionTime,BidMoney,BidMark,BidDeptAddr,BidTime,BidDept,BidUser,BidUserTel,BidUserMobile,AddUser,AddTime,Remark,I_xh,FlowState,IsValid) values");
builder.Append("(");
builder.Append("'" + model.UID + "',");
builder.Append(model.CorpID + ",");
builder.Append("'" + model.CallBidID + "',");
builder.Append("'" + model.ConstructionTime + "',");
builder.Append("'" + model.BidMoney + "',");
builder.Append("'" + model.BidMark + "',");
builder.Append("'" + model.BidDept + "',");
builder.Append("'" + model.BidTime + "',");
builder.Append("'" + model.BidDept + "',");
builder.Append("'" + model.BidUser + "',");
builder.Append("'" + model.BidUserTel + "',");
builder.Append("'" + model.BidUserMobile + "',");
builder.Append("'" + model.AddUser + "',");
builder.Append("'" + model.AddTime + "',");
builder.Append("'" + model.Remark + "',");
builder.Append(model.I_xh + ",");
builder.Append(model.FlowState + ",");
builder.Append("'" + model.IsValid + "'");
builder.Append(")");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
public bool EditCallBidsCrop(BidCorpModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OPM_CallBids_BidCorp set ");
builder.AppendFormat("CorpID={0},", model.CorpID);
builder.AppendFormat("CallBidID='{0}',", model.CallBidID);
builder.AppendFormat("ConstructionTime='{0}',", model.ConstructionTime);
builder.AppendFormat("BidMoney={0},", model.BidMoney);
builder.AppendFormat("BidMark='{0}',", model.BidMark);
builder.AppendFormat("BidDeptAddr='{0}',", model.BidDeptAddr);
builder.AppendFormat("BidTime='{0}',", model.BidTime);
builder.AppendFormat("BidDept='{0}',", model.BidDept);
builder.AppendFormat("BidUser='******',", model.BidUser);
builder.AppendFormat("BidUserTel='{0}',", model.BidUserTel);
builder.AppendFormat("BidUserMobile='{0}',", model.BidUserMobile);
builder.AppendFormat("AddUser='******',", model.AddUser);
builder.AppendFormat("AddTime='{0}',", model.AddTime);
builder.AppendFormat("Remark='{0}',", model.Remark);
builder.AppendFormat("I_xh={0},", model.I_xh);
builder.AppendFormat("FlowState={0},", model.FlowState);
builder.AppendFormat("IsValid='{0}'", model.IsValid);
builder.AppendFormat(" where UID='{0}'", model.UID);
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
