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