public static int UpdateTbl_ProjectArchiveVersion(Tbl_ProjectArchiveVersion tbl_projectarchiveversion)
{
WebCommon.Public.WriteLog("Ð޸İ汾£º" + tbl_projectarchiveversion.PAV_Info);
tbl_projectarchiveversion.DealUser = WebCommon.Public.GetUserName();
tbl_projectarchiveversion.DealTime = DateTime.Now;
return(new Tbl_ProjectArchiveVersionService().UpdateTbl_ProjectArchiveVersionById(tbl_projectarchiveversion));
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectArchiveVersion> getTbl_ProjectArchiveVersionsBySql(string sql)
{
IList <Tbl_ProjectArchiveVersion> list = new List <Tbl_ProjectArchiveVersion>();
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_ProjectArchiveVersion tbl_projectarchiveversion = new Tbl_ProjectArchiveVersion();
tbl_projectarchiveversion.ID = Convert.ToInt32(dr["ID"]);
tbl_projectarchiveversion.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_projectarchiveversion.ProjectArchiveID = Convert.ToInt32(dr["ProjectArchiveID"]);
tbl_projectarchiveversion.PAV_File = Convert.ToString(dr["PAV_File"]);
tbl_projectarchiveversion.PAV_Info = Convert.ToString(dr["PAV_Info"]);
tbl_projectarchiveversion.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_projectarchiveversion.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_projectarchiveversion.DealUser = Convert.ToString(dr["DealUser"]);
tbl_projectarchiveversion.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_projectarchiveversion);
}
}
return(list);
}
public int AddTbl_ProjectArchiveVersion(Tbl_ProjectArchiveVersion tbl_projectarchiveversion)
{
string sql = "insert into [Tbl_ProjectArchiveVersion] ([ProjectID],[ProjectArchiveID],[PAV_File],[PAV_Info],[DealUser]) values (@ProjectID,@ProjectArchiveID,@PAV_File,@PAV_Info,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", tbl_projectarchiveversion.ProjectID),
new SqlParameter("@ProjectArchiveID", tbl_projectarchiveversion.ProjectArchiveID),
new SqlParameter("@PAV_File", tbl_projectarchiveversion.PAV_File),
new SqlParameter("@PAV_Info", tbl_projectarchiveversion.PAV_Info),
new SqlParameter("@DealUser", tbl_projectarchiveversion.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_ProjectArchiveVersionById(Tbl_ProjectArchiveVersion tbl_projectarchiveversion)
{
string sql = "update [Tbl_ProjectArchiveVersion] set [ProjectID]=@ProjectID,[ProjectArchiveID]=@ProjectArchiveID,[PAV_File]=@PAV_File,[PAV_Info]=@PAV_Info,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_projectarchiveversion.ID),
new SqlParameter("@ProjectID", tbl_projectarchiveversion.ProjectID),
new SqlParameter("@ProjectArchiveID", tbl_projectarchiveversion.ProjectArchiveID),
new SqlParameter("@PAV_File", tbl_projectarchiveversion.PAV_File),
new SqlParameter("@PAV_Info", tbl_projectarchiveversion.PAV_Info),
new SqlParameter("@DealUser", tbl_projectarchiveversion.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_ProjectArchiveVersion(Tbl_ProjectArchiveVersion tbl_projectarchiveversion)
{
WebCommon.Public.WriteLog("Ìí¼Ó°æ±¾£º" + tbl_projectarchiveversion.PAV_Info);
return(new Tbl_ProjectArchiveVersionService().AddTbl_ProjectArchiveVersion(tbl_projectarchiveversion));
}
