private ProjectForepart GetProjectForepartFromDataRow(DataRow dr)
{
ProjectForepart forepart = new ProjectForepart {
ProjectCode = new Guid(dr["ProjectCode"].ToString()),
ProjectType = (int)dr["ProjectType"],
ProjectManualCode = dr["ProjectManualCode"].ToString(),
ProjectName = dr["ProjectName"].ToString(),
OwnerCode = (int)dr["OwnerCode"],
Contact = dr["Contact"].ToString(),
Locus = dr["Locus"].ToString(),
ProjectIntro = dr["ProjectIntro"].ToString(),
MainWork = dr["MainWork"].ToString(),
FundQuarry = dr["FundQuarry"].ToString(),
Remark = dr["Remark"].ToString(),
State = (ProjectState)Enum.Parse(typeof(ProjectState), dr["State"].ToString()),
RekonPrice = (decimal)dr["RekonPrice"],
AddDate = (DateTime)dr["AddDate"]
};
try
{
forepart.PrjFollow = dr["PrjFollow"].ToString();
}
catch
{
}
return(forepart);
}
public int UpdProjectForepart(ProjectForepart pf, string type)
{
string str = "";
str = ((((((str + " update EPM_Prj_ForePart set ") + " ProjectType = " + pf.ProjectType.ToString() + ",") + " ProjectManualCode = '" + pf.ProjectManualCode + "',") + " ProjectName = '" + pf.ProjectName + "',") + " OwnerCode = " + pf.OwnerCode.ToString() + ",") + " Locus = '" + pf.Locus + "',") + " ProjectIntro = '" + pf.ProjectIntro + "' ";
if (type == "Forepart")
{
str = ((((((str + " ,MainWork = '" + pf.MainWork + "',") + " Contact = '" + pf.Contact + "',") + " FundQuarry = '" + pf.FundQuarry + "',") + " RekonPrice = " + pf.RekonPrice.ToString() + ",") + " Remark = '" + pf.Remark + "',") + " AddDate = '" + pf.AddDate.ToString() + "',") + " PrjFollow = '" + pf.PrjFollow + "' ";
}
return(publicDbOpClass.ExecSqlString(str + " where ProjectCode = '" + pf.ProjectCode.ToString() + "'"));
}
public int AddProjectForepart(ProjectForepart pf)
{
string str = "";
object obj2 = str + "insert into EPM_Prj_Forepart(ProjectCode,ProjectType,ProjectManualCode,ProjectName,OwnerCode,Contact,Locus,ProjectIntro,MainWork,FundQuarry,RekonPrice,Remark,State,AddDate,PrjState)";
string str2 = string.Concat(new object[] { obj2, " values('", pf.ProjectCode, "',", pf.ProjectType.ToString() });
string str3 = str2 + ",'" + pf.ProjectManualCode + "','" + pf.ProjectName + "'," + pf.OwnerCode.ToString();
object obj3 = str3 + ",'" + pf.Contact + "','" + pf.Locus + "','" + pf.ProjectIntro + "','" + pf.MainWork + "'";
object obj4 = string.Concat(new object[] { obj3, ",'", pf.FundQuarry, "',", pf.RekonPrice.ToString(), ",'", pf.Remark, "',", Convert.ToInt32(pf.State) });
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj4, ",'", pf.AddDate.ToString(), "','", pf.Prjtate, "')" })));
}
public ProjectForepart QuerySingleProjectForepart(Guid projectCode)
{
ProjectForepart projectForepartFromDataRow = null;
using (DataTable table = publicDbOpClass.DataTableQuary("select * from EPM_Prj_Forepart where ProjectCode = '" + projectCode.ToString() + "'"))
{
if (table.Rows.Count > 0)
{
projectForepartFromDataRow = this.GetProjectForepartFromDataRow(table.Rows[0]);
}
}
return(projectForepartFromDataRow);
}
public int ProjectInfoUp(BidInfo Bid, ProjectForepart pf, InviteBid objBid)
{
object obj2 = ((" begin" + " update EPM_Bid_BidList set ") + " Principal='" + Bid.Principal + "', ") + " BidDeptID=" + Bid.BidDeptID.ToString() + ", ";
object obj3 = string.Concat(new object[] { obj2, " SubmitCetificateDate='", Bid.SubmitCetificateDate, "', " });
object obj4 = string.Concat(new object[] { obj3, " SubmitBailDate='", Bid.SubmitBailDate, "', " });
object obj5 = (((string.Concat(new object[] { obj4, " SubmitBidDate='", Bid.SubmitBidDate, "', " }) + " Envelopment='" + Bid.Envelopment + "', ") + " OriginalSum='" + Bid.OriginalSum + "', ") + " CopySum='" + Bid.CopySum + "', ") + " BidProjectManager='" + Bid.BidProjectManager + "', ";
object obj6 = (string.Concat(new object[] { obj5, " BidPrice='", Bid.BidPrice, "'," }) + " BidRemark='" + Bid.BidRemark + "'") + " where ";
object obj7 = ((((((((string.Concat(new object[] { obj6, " InviteBidCode='", Bid.InviteBidCode, "' " }) + " update EPM_Prj_ForePart set ") + " ProjectType = " + pf.ProjectType.ToString() + ",") + " ProjectManualCode = '" + pf.ProjectManualCode + "',") + " ProjectName = '" + pf.ProjectName + "',") + " OwnerCode = " + pf.OwnerCode.ToString() + ",") + " Contact = '" + pf.Contact + "',") + " Locus = '" + pf.Locus + "',") + " ProjectIntro = '" + pf.ProjectIntro + "',") + " AddDate = '" + pf.AddDate.ToString() + "',";
object obj8 = (string.Concat(new object[] { obj7, " PrjState = ", pf.Prjtate, " " }) + " where ProjectCode = '" + pf.ProjectCode.ToString() + "'") + " update EPM_Bid_InviteBid set";
object obj9 = string.Concat(new object[] { obj8, " IssueDate='", objBid.IssueDate, "', " });
object obj10 = string.Concat(new object[] { obj9, " BidType='", objBid.BidType, "', " });
object obj11 = (string.Concat(new object[] { obj10, " BidMode='", objBid.BidMode, "', " }) + " BidRequest='" + objBid.BidRequest + "', ") + " BidLocus='" + objBid.BidLocus + "', ";
object obj12 = string.Concat(new object[] { obj11, " CloseDate='", objBid.CloseDate, "', " }) + " AgentInfo='" + objBid.AgentInfo + "', ";
object obj13 = string.Concat(new object[] { obj12, " BidPaperPrice='", objBid.BidPaperPrice, "', " });
object obj14 = string.Concat(new object[] { obj13, " AddDate='", objBid.AddDate, "' " }) + " where ";
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj14, " ProjectCode='", objBid.ProjectCode, "' " }) + " end"));
}
public int ProjectInfoAdd(BidInfo Bid, ProjectForepart pf, InviteBid objBid)
{
object obj2 = (((((((("begin" + " insert into EPM_Bid_BidList ") + " (" + " InviteBidCode, ") + " Principal, " + " BidDeptID, ") + " SubmitCetificateDate, " + " SubmitBailDate, ") + " SubmitBidDate, " + " Envelopment, ") + " OriginalSum, " + " CopySum, ") + " BidProjectManager," + " BidPrice,") + " BidRemark,ProjectCode" + " ) ") + " values " + " (";
object obj3 = (string.Concat(new object[] { obj2, " '", Bid.InviteBidCode, "', " }) + " '" + Bid.Principal + "', ") + "\t " + Bid.BidDeptID.ToString() + ",";
object obj4 = string.Concat(new object[] { obj3, " '", Bid.SubmitCetificateDate, "', " });
object obj5 = string.Concat(new object[] { obj4, " '", Bid.SubmitBailDate, "', " });
object obj6 = (((string.Concat(new object[] { obj5, " '", Bid.SubmitBidDate, "', " }) + " '" + Bid.Envelopment + "', ") + " '" + Bid.OriginalSum + "', ") + " '" + Bid.CopySum + "', ") + " '" + Bid.BidProjectManager + "', ";
object obj7 = string.Concat(new object[] { obj6, " '", Bid.BidPrice, "'," });
object obj8 = string.Concat(new object[] { obj7, " '", Bid.BidRemark, "','", pf.ProjectCode, "'" }) + " ) ";
string str2 = string.Concat(new object[] { obj8, "insert into EPM_Prj_Forepart values('", pf.ProjectCode, "',", pf.ProjectType.ToString() });
string str3 = str2 + ",'" + pf.ProjectManualCode + "','" + pf.ProjectName + "'," + pf.OwnerCode.ToString();
object obj9 = str3 + ",'" + pf.Contact + "','" + pf.Locus + "','" + pf.ProjectIntro + "','" + pf.MainWork + "'";
object obj10 = string.Concat(new object[] { obj9, ",'", pf.FundQuarry, "',", pf.RekonPrice.ToString(), ",'", pf.Remark, "',", Convert.ToInt32(pf.State) });
object obj11 = ((((((((string.Concat(new object[] { obj10, ",'", pf.AddDate.ToString(), "',", pf.Prjtate, ",'", pf.PrjFollow, "')" }) + " insert into EPM_Bid_InviteBid " + " ( ") + " InviteBidCode, " + " ProjectCode, ") + " IssueDate, " + " BidType, ") + " BidMode, " + " BidRequest, ") + " BidLocus, " + " CloseDate, ") + " AgentInfo, " + " BidPaperPrice, ") + " Remark, " + " AddDate, ") + " CollectMode " + " ) ") + " values " + " ( ";
object obj12 = string.Concat(new object[] { obj11, " '", objBid.InviteBidCode, "', " });
object obj13 = string.Concat(new object[] { obj12, " '", objBid.ProjectCode, "', " });
object obj14 = string.Concat(new object[] { obj13, " '", objBid.IssueDate, "', " });
object obj15 = string.Concat(new object[] { obj14, " '", objBid.BidType, "', " });
object obj16 = (string.Concat(new object[] { obj15, " '", objBid.BidMode, "', " }) + " '" + objBid.BidRequest + "', ") + " '" + objBid.BidLocus + "', ";
object obj17 = string.Concat(new object[] { obj16, " '", objBid.CloseDate, "', " }) + " '" + objBid.AgentInfo + "', ";
object obj18 = string.Concat(new object[] { obj17, " '", objBid.BidPaperPrice, "', " }) + " '" + objBid.Remark + "', ";
return(publicDbOpClass.ExecSqlString((string.Concat(new object[] { obj18, " '", objBid.AddDate, "', " }) + " '" + objBid.CollectMode + "' ") + " ) " + " end"));
}
