public static int UpdateTbl_ProjectOuter(Tbl_ProjectOuter tbl_projectouter)
{
WebCommon.Public.WriteLog("修改合作信息：" + tbl_projectouter.PO_Content);
tbl_projectouter.DealUser = WebCommon.Public.GetUserName();
tbl_projectouter.DealTime = DateTime.Now;
return(new Tbl_ProjectOuterService().UpdateTbl_ProjectOuterById(tbl_projectouter));
}
public int UpdateTbl_ProjectOuterById(Tbl_ProjectOuter Tbl_ProjectOuter)
{
string sql = "update [Tbl_ProjectOuter] set [ProjectID]=@ProjectID,[PO_CompanyID]=@PO_CompanyID,[PO_StartTime]=@PO_StartTime,[PO_Time1]=@PO_Time1,[PO_Time2]=@PO_Time2,[PO_Link]=@PO_Link,[PO_LinkPhone]=@PO_LinkPhone,[PO_Content]=@PO_Content,[PO_Name]=@PO_Name,[Remark]=@Remark,[PO_File]=@PO_File,[PO_Price]=@PO_Price,[PO_FeeType]=@PO_FeeType,[PO_Type]=@PO_Type,[Status]=@Status,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", Tbl_ProjectOuter.ID),
new SqlParameter("@ProjectID", Tbl_ProjectOuter.ProjectID),
new SqlParameter("@PO_CompanyID", Tbl_ProjectOuter.PO_CompanyID),
new SqlParameter("@PO_StartTime", Tbl_ProjectOuter.PO_StartTime),
new SqlParameter("@PO_Time1", Tbl_ProjectOuter.PO_Time1),
new SqlParameter("@PO_Time2", Tbl_ProjectOuter.PO_Time2),
new SqlParameter("@PO_Link", Tbl_ProjectOuter.PO_Link),
new SqlParameter("@PO_LinkPhone", Tbl_ProjectOuter.PO_LinkPhone),
new SqlParameter("@PO_Name", Tbl_ProjectOuter.PO_Name),
new SqlParameter("@PO_Content", Tbl_ProjectOuter.PO_Content),
new SqlParameter("@Remark", Tbl_ProjectOuter.Remark),
new SqlParameter("@PO_File", Tbl_ProjectOuter.PO_File),
new SqlParameter("@PO_Price", Tbl_ProjectOuter.PO_Price),
new SqlParameter("@PO_PricePay", Tbl_ProjectOuter.PO_PricePay),
new SqlParameter("@PO_PriceBill", Tbl_ProjectOuter.PO_PriceBill),
new SqlParameter("@PO_FeeType", Tbl_ProjectOuter.PO_FeeType),
new SqlParameter("@PO_Type", Tbl_ProjectOuter.PO_Type),
new SqlParameter("@Status", Tbl_ProjectOuter.Status),
new SqlParameter("@DealUser", Tbl_ProjectOuter.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int AddTbl_ProjectOuter(Tbl_ProjectOuter Tbl_ProjectOuter)
{
string sql = "insert into [Tbl_ProjectOuter] ([ProjectID],[PO_CompanyID],[PO_StartTime],[PO_Time1],[PO_Time2],[PO_Link],[PO_LinkPhone],[PO_Name],[PO_Content],[Remark],[PO_File],[PO_Price],[PO_PricePay],[PO_PriceBill],[PO_FeeType],[PO_Type],[Status],[DealUser]) values (@ProjectID,@PO_CompanyID,@PO_StartTime,@PO_Time1,@PO_Time2,@PO_Link,@PO_LinkPhone,@PO_Name,@PO_Content,@Remark,@PO_File,@PO_Price,@PO_PricePay,@PO_PriceBill,@PO_FeeType,@PO_Type,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", Tbl_ProjectOuter.ProjectID),
new SqlParameter("@PO_CompanyID", Tbl_ProjectOuter.PO_CompanyID),
new SqlParameter("@PO_StartTime", Tbl_ProjectOuter.PO_StartTime),
new SqlParameter("@PO_Time1", Tbl_ProjectOuter.PO_Time1),
new SqlParameter("@PO_Time2", Tbl_ProjectOuter.PO_Time2),
new SqlParameter("@PO_Link", Tbl_ProjectOuter.PO_Link),
new SqlParameter("@PO_LinkPhone", Tbl_ProjectOuter.PO_LinkPhone),
new SqlParameter("@PO_Name", Tbl_ProjectOuter.PO_Name),
new SqlParameter("@PO_Content", Tbl_ProjectOuter.PO_Content),
new SqlParameter("@Remark", Tbl_ProjectOuter.Remark),
new SqlParameter("@PO_File", Tbl_ProjectOuter.PO_File),
new SqlParameter("@PO_Price", Tbl_ProjectOuter.PO_Price),
new SqlParameter("@PO_PricePay", Tbl_ProjectOuter.PO_PricePay),
new SqlParameter("@PO_PriceBill", Tbl_ProjectOuter.PO_PriceBill),
new SqlParameter("@PO_FeeType", Tbl_ProjectOuter.PO_FeeType),
new SqlParameter("@PO_Type", Tbl_ProjectOuter.PO_Type),
new SqlParameter("@Status", Tbl_ProjectOuter.Status),
new SqlParameter("@DealUser", Tbl_ProjectOuter.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectOuter> getTbl_ProjectOutersBySql(string sql)
{
IList <Tbl_ProjectOuter> list = new List <Tbl_ProjectOuter>();
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_ProjectOuter Tbl_ProjectOuter = new Tbl_ProjectOuter();
Tbl_ProjectOuter.ID = Convert.ToInt32(dr["ID"]);
Tbl_ProjectOuter.ProjectID = Convert.ToInt32(dr["ProjectID"]);
Tbl_ProjectOuter.PO_CompanyID = Convert.ToInt32(dr["PO_CompanyID"]);
Tbl_ProjectOuter.PO_StartTime = Convert.ToDateTime(dr["PO_StartTime"]);
Tbl_ProjectOuter.PO_Time1 = Convert.ToDateTime(dr["PO_Time1"]);
Tbl_ProjectOuter.PO_Time2 = Convert.ToDateTime(dr["PO_Time2"]);
Tbl_ProjectOuter.PO_Link = Convert.ToString(dr["PO_Link"]);
Tbl_ProjectOuter.PO_LinkPhone = Convert.ToString(dr["PO_LinkPhone"]);
Tbl_ProjectOuter.PO_Name = Convert.ToString(dr["PO_Name"]);
Tbl_ProjectOuter.PO_Content = Convert.ToString(dr["PO_Content"]);
Tbl_ProjectOuter.Remark = Convert.ToString(dr["Remark"]);
Tbl_ProjectOuter.PO_File = Convert.ToString(dr["PO_File"]);
Tbl_ProjectOuter.PO_Price = Convert.ToDouble(dr["PO_Price"]);
Tbl_ProjectOuter.PO_PricePay = Convert.ToDouble(dr["PO_PricePay"]);
Tbl_ProjectOuter.PO_PriceBill = Convert.ToDouble(dr["PO_PriceBill"]);
Tbl_ProjectOuter.PO_FeeType = Convert.ToString(dr["PO_FeeType"]);
Tbl_ProjectOuter.PO_Type = Convert.ToString(dr["PO_Type"]);
Tbl_ProjectOuter.Status = Convert.ToString(dr["Status"]);
Tbl_ProjectOuter.AddDate = Convert.ToDateTime(dr["AddDate"]);
Tbl_ProjectOuter.DealFlag = Convert.ToInt32(dr["DealFlag"]);
Tbl_ProjectOuter.DealUser = Convert.ToString(dr["DealUser"]);
Tbl_ProjectOuter.DealTime = Convert.ToDateTime(dr["DealTime"]);
list.Add(Tbl_ProjectOuter);
}
}
return(list);
}
public static int AddTbl_ProjectOuter(Tbl_ProjectOuter tbl_projectouter)
{
WebCommon.Public.WriteLog("添加合作信息：" + tbl_projectouter.PO_Content);
return(new Tbl_ProjectOuterService().AddTbl_ProjectOuter(tbl_projectouter));
}
