public static int UpdateTbl_ProjectBid(Tbl_ProjectBid tbl_projectbid)
{
WebCommon.Public.WriteLog("修改客户信息：" + tbl_projectbid.PB_Name);
tbl_projectbid.DealUser = WebCommon.Public.GetUserName();
tbl_projectbid.DealTime = DateTime.Now;
return(new Tbl_ProjectBidService().UpdateTbl_ProjectBidById(tbl_projectbid));
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectBid> getTbl_ProjectBidsBySql(string sql)
{
IList <Tbl_ProjectBid> list = new List <Tbl_ProjectBid>();
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_ProjectBid tbl_projectbid = new Tbl_ProjectBid();
tbl_projectbid.ID = Convert.ToInt32(dr["ID"]);
tbl_projectbid.PB_Name = Convert.ToString(dr["PB_Name"]);
tbl_projectbid.PB_Info = Convert.ToString(dr["PB_Info"]);
tbl_projectbid.Remark = Convert.ToString(dr["Remark"]);
tbl_projectbid.Status = Convert.ToString(dr["Status"]);
tbl_projectbid.AddDate = Convert.ToDateTime(dr["AddDate"]);
tbl_projectbid.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_projectbid.DealUser = Convert.ToString(dr["DealUser"]);
tbl_projectbid.DealTime = Convert.ToDateTime(dr["DealTime"]);
list.Add(tbl_projectbid);
}
}
return(list);
}
public int AddTbl_ProjectBid(Tbl_ProjectBid tbl_projectbid)
{
string sql = "insert into [Tbl_ProjectBid] ([PB_Name],[PB_Info],[Status],[Remark],[DealUser]) values (@PB_Name,@PB_Info,@Status,@Remark,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@PB_Name", tbl_projectbid.PB_Name),
new SqlParameter("@PB_Info", tbl_projectbid.PB_Info),
new SqlParameter("@Status", tbl_projectbid.Status),
new SqlParameter("@Remark", tbl_projectbid.Remark),
new SqlParameter("@DealUser", tbl_projectbid.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_ProjectBidById(Tbl_ProjectBid tbl_projectbid)
{
string sql = "update [Tbl_ProjectBid] set [PB_Name]=@PB_Name,[PB_Info]=@PB_Info,[Status]=@Status,[Remark]=@Remark,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_projectbid.ID),
new SqlParameter("@PB_Name", tbl_projectbid.PB_Name),
new SqlParameter("@PB_Info", tbl_projectbid.PB_Info),
new SqlParameter("@Status", tbl_projectbid.Status),
new SqlParameter("@Remark", tbl_projectbid.Remark),
new SqlParameter("@DealUser", tbl_projectbid.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_ProjectBid(Tbl_ProjectBid tbl_projectbid)
{
WebCommon.Public.WriteLog("添加客户信息：" + tbl_projectbid.PB_Name);
return(new Tbl_ProjectBidService().AddTbl_ProjectBid(tbl_projectbid));
}
