public static int UpdateTbl_DesignVolume(Tbl_DesignVolume tbl_designvolume)
{
WebCommon.Public.WriteLog("Ð޸ľí²á£º" + tbl_designvolume.VolumeName);
tbl_designvolume.DealUser = WebCommon.Public.GetUserName();
tbl_designvolume.DealTime = DateTime.Now;
return(new Tbl_DesignVolumeService().UpdateTbl_DesignVolumeById(tbl_designvolume));
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_DesignVolume> geTbl_DesignVolumesBySql(string sql)
{
IList <Tbl_DesignVolume> list = new List <Tbl_DesignVolume>();
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_DesignVolume tbl_designvolume = new Tbl_DesignVolume();
tbl_designvolume.ID = Convert.ToInt32(dr["ID"]);
tbl_designvolume.ClassName1 = Convert.ToString(dr["ClassName1"]);
tbl_designvolume.ClassName2 = Convert.ToString(dr["ClassName2"]);
tbl_designvolume.ClassName3 = Convert.ToString(dr["ClassName3"]);
tbl_designvolume.VolumeNo = Convert.ToString(dr["VolumeNo"]);
tbl_designvolume.VolumeName = Convert.ToString(dr["VolumeName"]);
tbl_designvolume.Volume25MW = Convert.ToInt32(dr["Volume25MW"]);
tbl_designvolume.Volume50MW = Convert.ToInt32(dr["Volume50MW"]);
tbl_designvolume.VolumeLevel = Convert.ToString(dr["VolumeLevel"]);
tbl_designvolume.Remark = Convert.ToString(dr["Remark"]);
tbl_designvolume.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_designvolume.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_designvolume.DealUser = Convert.ToString(dr["DealUser"]);
tbl_designvolume.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_designvolume);
}
}
return(list);
}
public int AddTbl_DesignVolume(Tbl_DesignVolume tbl_designvolume)
{
string sql = "insert into [Tbl_DesignVolume] ([ClassName1],[ClassName2],[ClassName3],[VolumeNo],[VolumeName],[Volume25MW],[Volume50MW],[VolumeLevel],[Remark],[DealUser]) values (@ClassName1,@ClassName2,@ClassName3,@VolumeNo,@VolumeName,@Volume25MW,@Volume50MW,@VolumeLevel,@Remark,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ClassName1", tbl_designvolume.ClassName1),
new SqlParameter("@ClassName2", tbl_designvolume.ClassName2),
new SqlParameter("@ClassName3", tbl_designvolume.ClassName3),
new SqlParameter("@VolumeNo", tbl_designvolume.VolumeNo),
new SqlParameter("@VolumeName", tbl_designvolume.VolumeName),
new SqlParameter("@Volume25MW", tbl_designvolume.Volume25MW),
new SqlParameter("@Volume50MW", tbl_designvolume.Volume50MW),
new SqlParameter("@VolumeLevel", tbl_designvolume.VolumeLevel),
new SqlParameter("@Remark", tbl_designvolume.Remark),
new SqlParameter("@DealUser", tbl_designvolume.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_DesignVolumeById(Tbl_DesignVolume tbl_designvolume)
{
string sql = "update [Tbl_DesignVolume] set [ClassName1]=@ClassName1,[ClassName2]=@ClassName2,[ClassName3]=@ClassName3,[VolumeNo]=@VolumeNo,[VolumeName]=@VolumeName,[Volume25MW]=@Volume25MW,[Volume50MW]=@Volume50MW,[VolumeLevel]=@VolumeLevel,[Remark]=@Remark,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_designvolume.ID),
new SqlParameter("@ClassName1", tbl_designvolume.ClassName1),
new SqlParameter("@ClassName2", tbl_designvolume.ClassName2),
new SqlParameter("@ClassName3", tbl_designvolume.ClassName3),
new SqlParameter("@VolumeNo", tbl_designvolume.VolumeNo),
new SqlParameter("@VolumeName", tbl_designvolume.VolumeName),
new SqlParameter("@Volume25MW", tbl_designvolume.Volume25MW),
new SqlParameter("@Volume50MW", tbl_designvolume.Volume50MW),
new SqlParameter("@VolumeLevel", tbl_designvolume.VolumeLevel),
new SqlParameter("@Remark", tbl_designvolume.Remark),
new SqlParameter("@DealUser", tbl_designvolume.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_DesignVersion(Tbl_DesignVolume tbl_designvolume)
{
WebCommon.Public.WriteLog("Ìí¼Ó¾í²á£º" + tbl_designvolume.VolumeName);
return(new Tbl_DesignVolumeService().AddTbl_DesignVolume(tbl_designvolume));
}
