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)); }