/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectContract> getTbl_ProjectContractsBySql(string sql)
{
IList <Tbl_ProjectContract> list = new List <Tbl_ProjectContract>();
DataSet ds = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Tbl_ProjectContract tbl_projectcontract = new Tbl_ProjectContract();
tbl_projectcontract.ID = Convert.ToInt32(dr["ID"]);
tbl_projectcontract.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_projectcontract.PC_Name = Convert.ToString(dr["PC_Name"]);
tbl_projectcontract.PC_File = Convert.ToString(dr["PC_File"]);
tbl_projectcontract.PC_Price = Convert.ToDouble(dr["PC_Price"]);
tbl_projectcontract.PC_MoneyReceive = Convert.ToDouble(dr["PC_MoneyReceive"]);
tbl_projectcontract.PC_MoneyBill = Convert.ToDouble(dr["PC_MoneyBill"]);
tbl_projectcontract.PC_FeeType = Convert.ToString(dr["PC_FeeType"]);
tbl_projectcontract.Status = Convert.ToString(dr["Status"]);
tbl_projectcontract.AddDate = Convert.ToDateTime(dr["AddDate"]);
tbl_projectcontract.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_projectcontract.DealUser = Convert.ToString(dr["DealUser"]);
tbl_projectcontract.DealTime = Convert.ToDateTime(dr["DealTime"]);
list.Add(tbl_projectcontract);
}
}
return(list);
}
public static int UpdateTbl_ProjectContract(Tbl_ProjectContract tbl_projectcontract)
{
WebCommon.Public.WriteLog("修改合同：" + tbl_projectcontract.ProjectID);
tbl_projectcontract.DealUser = WebCommon.Public.GetUserName();
tbl_projectcontract.DealTime = DateTime.Now;
return(new Tbl_ProjectContractService().UpdateTbl_ProjectContractById(tbl_projectcontract));
}
public static int AddTbl_ProjectContract(Tbl_ProjectContract tbl_projectcontract)
{
WebCommon.Public.WriteLog("添加合同：" + tbl_projectcontract.ProjectID);
int count = new Tbl_ProjectContractService().AddTbl_ProjectContract(tbl_projectcontract);
if (count > 0)
{
//添加合同成功的时候更新项目的节点信息
WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(tbl_projectcontract.ProjectID);
project.ProjectNo = tbl_projectcontract.PC_Name; //生成项目编号
project.NodeNo = "确认设总";
project.NodeUser = WebBLL.Tbl_ConfigManager.GetTbl_ConfigById(1).C_Set5; //技术副院长
WebBLL.Tbl_ProjectManager.UpdateTbl_Project(project);
}
return(count);
}
public int AddTbl_ProjectContract(Tbl_ProjectContract tbl_projectcontract)
{
string sql = "insert into [Tbl_ProjectContract] ([ProjectID],[PC_Name],[PC_File],[PC_Price],[PC_MoneyReceive],[PC_MoneyBill],[PC_FeeType],[Status],[DealUser]) values (@ProjectID,@PC_Name,@PC_File,@PC_Price,@PC_MoneyReceive,@PC_MoneyBill,@PC_FeeType,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", tbl_projectcontract.ProjectID),
new SqlParameter("@PC_Name", tbl_projectcontract.PC_Name),
new SqlParameter("@PC_File", tbl_projectcontract.PC_File),
new SqlParameter("@PC_Price", tbl_projectcontract.PC_Price),
new SqlParameter("@PC_MoneyReceive", tbl_projectcontract.PC_MoneyReceive),
new SqlParameter("@PC_MoneyBill", tbl_projectcontract.PC_MoneyBill),
new SqlParameter("@PC_FeeType", tbl_projectcontract.PC_FeeType),
new SqlParameter("@Status", tbl_projectcontract.Status),
new SqlParameter("@DealUser", tbl_projectcontract.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_ProjectContractById(Tbl_ProjectContract tbl_projectcontract)
{
string sql = "update [Tbl_ProjectContract] set [ProjectID]=@ProjectID,[PC_Name]=@PC_Name,[PC_File]=@PC_File,[PC_MoneyBill]=@PC_MoneyBill,[PC_MoneyReceive]=@PC_MoneyReceive,[PC_Price]=@PC_Price,[PC_FeeType]=@PC_FeeType,[Status]=@Status,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_projectcontract.ID),
new SqlParameter("@ProjectID", tbl_projectcontract.ProjectID),
new SqlParameter("@PC_Name", tbl_projectcontract.PC_Name),
new SqlParameter("@PC_File", tbl_projectcontract.PC_File),
new SqlParameter("@PC_Price", tbl_projectcontract.PC_Price),
new SqlParameter("@PC_MoneyReceive", tbl_projectcontract.PC_MoneyReceive),
new SqlParameter("@PC_MoneyBill", tbl_projectcontract.PC_MoneyBill),
new SqlParameter("@PC_FeeType", tbl_projectcontract.PC_FeeType),
new SqlParameter("@Status", tbl_projectcontract.Status),
new SqlParameter("@DealUser", tbl_projectcontract.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}