/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_DesignVersion> getTbl_DesignVersionsBySql(string sql)
{
IList <Tbl_DesignVersion> list = new List <Tbl_DesignVersion>();
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_DesignVersion tbl_designversion = new Tbl_DesignVersion();
tbl_designversion.ID = Convert.ToInt32(dr["ID"]);
tbl_designversion.UserName = Convert.ToString(dr["UserName"]);
tbl_designversion.DesignTaskID = Convert.ToInt32(dr["DesignTaskID"]);
tbl_designversion.CadFile = Convert.ToString(dr["CadFile"]);
tbl_designversion.Remark = Convert.ToString(dr["Remark"]);
tbl_designversion.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_designversion.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_designversion.DealUser = Convert.ToString(dr["DealUser"]);
tbl_designversion.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_designversion);
}
}
return(list);
}
public static int UpdateTbl_DesignVersion(Tbl_DesignVersion tbl_designversion)
{
WebCommon.Public.WriteLog("修改设计版本：" + tbl_designversion.DesignTaskID);
tbl_designversion.DealUser = WebCommon.Public.GetUserName();
tbl_designversion.DealTime = DateTime.Now;
return(new Tbl_DesignVersionService().UpdateTbl_DesignVersionById(tbl_designversion));
}
public int AddTbl_DesignVersion(Tbl_DesignVersion tbl_designversion)
{
string sql = "insert into [Tbl_DesignVersion] ([UserName],[DesignTaskID],[CadFile],[Remark],[DealUser]) values (@UserName,@DesignTaskID,@CadFile,@Remark,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserName", tbl_designversion.UserName),
new SqlParameter("@DesignTaskID", tbl_designversion.DesignTaskID),
new SqlParameter("@CadFile", tbl_designversion.CadFile),
new SqlParameter("@Remark", tbl_designversion.Remark),
new SqlParameter("@DealUser", tbl_designversion.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_DesignVersionById(Tbl_DesignVersion tbl_designversion)
{
string sql = "update [Tbl_DesignVersion] set [UserName]=@UserName,[DesignTaskID]=@DesignTaskID,[CadFile]=@CadFile,[Remark]=@Remark,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_designversion.ID),
new SqlParameter("@UserName", tbl_designversion.UserName),
new SqlParameter("@DesignTaskID", tbl_designversion.DesignTaskID),
new SqlParameter("@CadFile", tbl_designversion.CadFile),
new SqlParameter("@Remark", tbl_designversion.Remark),
new SqlParameter("@DealUser", tbl_designversion.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_DesignVersion(Tbl_DesignVersion tbl_designversion)
{
WebCommon.Public.WriteLog("添加设计版本：" + tbl_designversion.DesignTaskID);
return(new Tbl_DesignVersionService().AddTbl_DesignVersion(tbl_designversion));
}