/// <summary> /// 新增一个部门(监控地点) /// </summary> /// <param name="deptInfo">新增的部门对象</param> /// <returns>执行该SQL语句后影响的行数</returns> public static int AddDeptInfo(DeptInfo deptInfo) { string sql = "INSERT INTO deptInfo(dAddreass,dVedio,dDesc,dFilePath,isUsable,sID)" + "values(@dAddress,@dVedio,@dDesc,@dFilePath,@isUsable,@sID)"; SqlParameter[] par = new SqlParameter[] { new SqlParameter("@dAddress",deptInfo.DAddress), new SqlParameter("@dVedio",deptInfo.DVideo), new SqlParameter("@dDesc",deptInfo.DDesc), new SqlParameter("@dFilePath",deptInfo.DFilePath), new SqlParameter("@isUsable",deptInfo.IsUsable), new SqlParameter("@sID",deptInfo.SystemType.StID) }; return DBHelper.GetScalar(sql,par); }
/// <summary> /// 私有方法 从数据行里获取数据填充到对象中 /// </summary> /// <param name="row">包含具体数据的行</param> /// <returns>拥有数据的DeptInfo对象</returns> private static DeptInfo GetDeptInfoByDateRow(DataRow row) { DeptInfo deptInfo = new DeptInfo(); deptInfo.DID = Convert.ToInt32(row["dID"].ToString()); deptInfo.DAddress = (string)row["dAddress"].ToString(); deptInfo.DDesc = (string)row["dDesc"].ToString(); deptInfo.DFilePath = (string)row["dFilePath"].ToString(); deptInfo.DVideo = (string)row["dVideo"].ToString(); deptInfo.IsUsable = Convert.ToInt32(row["isUsable"].ToString()); deptInfo.DInTime = Convert.ToDateTime(row["dInTime"]); deptInfo.DIndex = Convert.ToInt32(row["dIndex"].ToString()); deptInfo.SystemType = (SystemType)SystemTypeService.GetSystemTypeByID(Convert.ToInt32(row["sID"])); return deptInfo; }
/// <summary> /// 更新指定的部门信息 /// </summary> /// <param name="deptInfo">被更新的部门对象</param> /// <returns>执行后受影响的行数</returns> public static int ModifyDeptInfoBy(DeptInfo deptInfo) { string sql = "UPDATE deptInfo SET dAddress = @dAddress,dVedio = @dVedio, dDesc = @dDesc,dFilePath = @dFilePath,isUsable = @isUsable," + "sID = @sID WHERE dID = @dID"; SqlParameter[] par = new SqlParameter[] { new SqlParameter("@dAddress",deptInfo.DAddress), new SqlParameter("@dVedio",deptInfo.DVideo), new SqlParameter("@dDesc",deptInfo.DDesc), new SqlParameter("@dFilePath",deptInfo.DFilePath), new SqlParameter("@isUsable",deptInfo.IsUsable), new SqlParameter("@sID",deptInfo.SystemType.StID), new SqlParameter("@dID",deptInfo.DID) }; return DBHelper.GetScalar(sql,par); }