/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.V_Station2 GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 AreaName,CompanyCode,CompanyName,PointCode,PointCode1,PointName,PointUses,是否运维,IsPatrol,是否巡检,IsContract,是否合同,PointType,Name,OutletNo,PassTime,EnvirLevel,OperatedLevel,OperatedCenter,OperatedGroup,Director,MnCode,RouterIP,DataIP,VedioIP,LineNo,Vlan,NetOperator,NetType,remark,UpdateTime,UpdatePerson,CompanyID,PointID,AreaCode,PointCodeB,frequency,latitude,Longitude,Pointaddress from V_Station2 ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Maticsoft.Model.V_Station2 model = new Maticsoft.Model.V_Station2();
DataSet ds = DbBaseHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.V_Station2 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into V_Station2(");
strSql.Append("AreaName,CompanyCode,CompanyName,PointCode,PointCode1,PointName,PointUses,是否运维,IsPatrol,是否巡检,IsContract,是否合同,PointType,Name,OutletNo,PassTime,EnvirLevel,OperatedLevel,OperatedCenter,OperatedGroup,Director,MnCode,RouterIP,DataIP,VedioIP,LineNo,Vlan,NetOperator,NetType,remark,UpdateTime,UpdatePerson,CompanyID,PointID,AreaCode,PointCodeB,frequency,latitude,Longitude,Pointaddress)");
strSql.Append(" values (");
strSql.Append("@AreaName,@CompanyCode,@CompanyName,@PointCode,@PointCode1,@PointName,@PointUses,@是否运维,@IsPatrol,@是否巡检,@IsContract,@是否合同,@PointType,@Name,@OutletNo,@PassTime,@EnvirLevel,@OperatedLevel,@OperatedCenter,@OperatedGroup,@Director,@MnCode,@RouterIP,@DataIP,@VedioIP,@LineNo,@Vlan,@NetOperator,@NetType,@remark,@UpdateTime,@UpdatePerson,@CompanyID,@PointID,@AreaCode,@PointCodeB,@frequency,@latitude,@Longitude,@Pointaddress)");
SqlParameter[] parameters =
{
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20),
new SqlParameter("@PointCode1", SqlDbType.NVarChar, 20),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointUses", SqlDbType.Bit, 1),
new SqlParameter("@是否运维", SqlDbType.VarChar, 4),
new SqlParameter("@IsPatrol", SqlDbType.Bit, 1),
new SqlParameter("@是否巡检", SqlDbType.VarChar, 6),
new SqlParameter("@IsContract", SqlDbType.Bit, 1),
new SqlParameter("@是否合同", SqlDbType.VarChar, 2),
new SqlParameter("@PointType", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
new SqlParameter("@OutletNo", SqlDbType.NVarChar, 20),
new SqlParameter("@PassTime", SqlDbType.DateTime),
new SqlParameter("@EnvirLevel", SqlDbType.NVarChar, 50),
new SqlParameter("@OperatedLevel", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedCenter", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedGroup", SqlDbType.NVarChar, 20),
new SqlParameter("@Director", SqlDbType.NVarChar, 50),
new SqlParameter("@MnCode", SqlDbType.NVarChar, 20),
new SqlParameter("@RouterIP", SqlDbType.NVarChar, 255),
new SqlParameter("@DataIP", SqlDbType.NVarChar, 255),
new SqlParameter("@VedioIP", SqlDbType.NVarChar, 255),
new SqlParameter("@LineNo", SqlDbType.NVarChar, 50),
new SqlParameter("@Vlan", SqlDbType.NVarChar, 20),
new SqlParameter("@NetOperator", SqlDbType.NVarChar, 20),
new SqlParameter("@NetType", SqlDbType.NVarChar, 20),
new SqlParameter("@remark", SqlDbType.NVarChar, 255),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyID", SqlDbType.Int, 4),
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@AreaCode", SqlDbType.NVarChar, 15),
new SqlParameter("@PointCodeB", SqlDbType.NVarChar, 50),
new SqlParameter("@frequency", SqlDbType.Int, 4),
new SqlParameter("@latitude", SqlDbType.NVarChar, 50),
new SqlParameter("@Longitude", SqlDbType.NVarChar, 50),
new SqlParameter("@Pointaddress", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.AreaName;
parameters[1].Value = model.CompanyCode;
parameters[2].Value = model.CompanyName;
parameters[3].Value = model.PointCode;
parameters[4].Value = model.PointCode1;
parameters[5].Value = model.PointName;
parameters[6].Value = model.PointUses;
parameters[7].Value = model.是否运维;
parameters[8].Value = model.IsPatrol;
parameters[9].Value = model.是否巡检;
parameters[10].Value = model.IsContract;
parameters[11].Value = model.是否合同;
parameters[12].Value = model.PointType;
parameters[13].Value = model.Name;
parameters[14].Value = model.OutletNo;
parameters[15].Value = model.PassTime;
parameters[16].Value = model.EnvirLevel;
parameters[17].Value = model.OperatedLevel;
parameters[18].Value = model.OperatedCenter;
parameters[19].Value = model.OperatedGroup;
parameters[20].Value = model.Director;
parameters[21].Value = model.MnCode;
parameters[22].Value = model.RouterIP;
parameters[23].Value = model.DataIP;
parameters[24].Value = model.VedioIP;
parameters[25].Value = model.LineNo;
parameters[26].Value = model.Vlan;
parameters[27].Value = model.NetOperator;
parameters[28].Value = model.NetType;
parameters[29].Value = model.remark;
parameters[30].Value = model.UpdateTime;
parameters[31].Value = model.UpdatePerson;
parameters[32].Value = model.CompanyID;
parameters[33].Value = model.PointID;
parameters[34].Value = model.AreaCode;
parameters[35].Value = model.PointCodeB;
parameters[36].Value = model.frequency;
parameters[37].Value = model.latitude;
parameters[38].Value = model.Longitude;
parameters[39].Value = model.Pointaddress;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.V_Station2 DataRowToModel(DataRow row)
{
Maticsoft.Model.V_Station2 model = new Maticsoft.Model.V_Station2();
if (row != null)
{
if (row["AreaName"] != null)
{
model.AreaName = row["AreaName"].ToString();
}
if (row["CompanyCode"] != null)
{
model.CompanyCode = row["CompanyCode"].ToString();
}
if (row["CompanyName"] != null)
{
model.CompanyName = row["CompanyName"].ToString();
}
if (row["PointCode"] != null)
{
model.PointCode = row["PointCode"].ToString();
}
if (row["PointCode1"] != null)
{
model.PointCode1 = row["PointCode1"].ToString();
}
if (row["PointName"] != null)
{
model.PointName = row["PointName"].ToString();
}
if (row["PointUses"] != null && row["PointUses"].ToString() != "")
{
if ((row["PointUses"].ToString() == "1") || (row["PointUses"].ToString().ToLower() == "true"))
{
model.PointUses = true;
}
else
{
model.PointUses = false;
}
}
if (row["是否运维"] != null)
{
model.是否运维 = row["是否运维"].ToString();
}
if (row["IsPatrol"] != null && row["IsPatrol"].ToString() != "")
{
if ((row["IsPatrol"].ToString() == "1") || (row["IsPatrol"].ToString().ToLower() == "true"))
{
model.IsPatrol = true;
}
else
{
model.IsPatrol = false;
}
}
if (row["是否巡检"] != null)
{
model.是否巡检 = row["是否巡检"].ToString();
}
if (row["IsContract"] != null && row["IsContract"].ToString() != "")
{
if ((row["IsContract"].ToString() == "1") || (row["IsContract"].ToString().ToLower() == "true"))
{
model.IsContract = true;
}
else
{
model.IsContract = false;
}
}
if (row["是否合同"] != null)
{
model.是否合同 = row["是否合同"].ToString();
}
if (row["PointType"] != null && row["PointType"].ToString() != "")
{
model.PointType = int.Parse(row["PointType"].ToString());
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["OutletNo"] != null)
{
model.OutletNo = row["OutletNo"].ToString();
}
if (row["PassTime"] != null && row["PassTime"].ToString() != "")
{
model.PassTime = DateTime.Parse(row["PassTime"].ToString());
}
if (row["EnvirLevel"] != null)
{
model.EnvirLevel = row["EnvirLevel"].ToString();
}
if (row["OperatedLevel"] != null)
{
model.OperatedLevel = row["OperatedLevel"].ToString();
}
if (row["OperatedCenter"] != null)
{
model.OperatedCenter = row["OperatedCenter"].ToString();
}
if (row["OperatedGroup"] != null)
{
model.OperatedGroup = row["OperatedGroup"].ToString();
}
if (row["Director"] != null)
{
model.Director = row["Director"].ToString();
}
if (row["MnCode"] != null)
{
model.MnCode = row["MnCode"].ToString();
}
if (row["RouterIP"] != null)
{
model.RouterIP = row["RouterIP"].ToString();
}
if (row["DataIP"] != null)
{
model.DataIP = row["DataIP"].ToString();
}
if (row["VedioIP"] != null)
{
model.VedioIP = row["VedioIP"].ToString();
}
if (row["LineNo"] != null)
{
model.LineNo = row["LineNo"].ToString();
}
if (row["Vlan"] != null)
{
model.Vlan = row["Vlan"].ToString();
}
if (row["NetOperator"] != null)
{
model.NetOperator = row["NetOperator"].ToString();
}
if (row["NetType"] != null)
{
model.NetType = row["NetType"].ToString();
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString());
}
if (row["UpdatePerson"] != null)
{
model.UpdatePerson = row["UpdatePerson"].ToString();
}
if (row["CompanyID"] != null && row["CompanyID"].ToString() != "")
{
model.CompanyID = int.Parse(row["CompanyID"].ToString());
}
if (row["PointID"] != null && row["PointID"].ToString() != "")
{
model.PointID = int.Parse(row["PointID"].ToString());
}
if (row["AreaCode"] != null)
{
model.AreaCode = row["AreaCode"].ToString();
}
if (row["PointCodeB"] != null)
{
model.PointCodeB = row["PointCodeB"].ToString();
}
if (row["frequency"] != null && row["frequency"].ToString() != "")
{
model.frequency = int.Parse(row["frequency"].ToString());
}
if (row["latitude"] != null)
{
model.latitude = row["latitude"].ToString();
}
if (row["Longitude"] != null)
{
model.Longitude = row["Longitude"].ToString();
}
if (row["Pointaddress"] != null)
{
model.Pointaddress = row["Pointaddress"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.V_Station2 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update V_Station2 set ");
strSql.Append("AreaName=@AreaName,");
strSql.Append("CompanyCode=@CompanyCode,");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("PointCode=@PointCode,");
strSql.Append("PointCode1=@PointCode1,");
strSql.Append("PointName=@PointName,");
strSql.Append("PointUses=@PointUses,");
strSql.Append("是否运维=@是否运维,");
strSql.Append("IsPatrol=@IsPatrol,");
strSql.Append("是否巡检=@是否巡检,");
strSql.Append("IsContract=@IsContract,");
strSql.Append("是否合同=@是否合同,");
strSql.Append("PointType=@PointType,");
strSql.Append("Name=@Name,");
strSql.Append("OutletNo=@OutletNo,");
strSql.Append("PassTime=@PassTime,");
strSql.Append("EnvirLevel=@EnvirLevel,");
strSql.Append("OperatedLevel=@OperatedLevel,");
strSql.Append("OperatedCenter=@OperatedCenter,");
strSql.Append("OperatedGroup=@OperatedGroup,");
strSql.Append("Director=@Director,");
strSql.Append("MnCode=@MnCode,");
strSql.Append("RouterIP=@RouterIP,");
strSql.Append("DataIP=@DataIP,");
strSql.Append("VedioIP=@VedioIP,");
strSql.Append("LineNo=@LineNo,");
strSql.Append("Vlan=@Vlan,");
strSql.Append("NetOperator=@NetOperator,");
strSql.Append("NetType=@NetType,");
strSql.Append("remark=@remark,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("UpdatePerson=@UpdatePerson,");
strSql.Append("CompanyID=@CompanyID,");
strSql.Append("PointID=@PointID,");
strSql.Append("AreaCode=@AreaCode,");
strSql.Append("PointCodeB=@PointCodeB,");
strSql.Append("frequency=@frequency,");
strSql.Append("latitude=@latitude,");
strSql.Append("Longitude=@Longitude,");
strSql.Append("Pointaddress=@Pointaddress");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20),
new SqlParameter("@PointCode1", SqlDbType.NVarChar, 20),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@PointUses", SqlDbType.Bit, 1),
new SqlParameter("@是否运维", SqlDbType.VarChar, 4),
new SqlParameter("@IsPatrol", SqlDbType.Bit, 1),
new SqlParameter("@是否巡检", SqlDbType.VarChar, 6),
new SqlParameter("@IsContract", SqlDbType.Bit, 1),
new SqlParameter("@是否合同", SqlDbType.VarChar, 2),
new SqlParameter("@PointType", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
new SqlParameter("@OutletNo", SqlDbType.NVarChar, 20),
new SqlParameter("@PassTime", SqlDbType.DateTime),
new SqlParameter("@EnvirLevel", SqlDbType.NVarChar, 50),
new SqlParameter("@OperatedLevel", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedCenter", SqlDbType.NVarChar, 20),
new SqlParameter("@OperatedGroup", SqlDbType.NVarChar, 20),
new SqlParameter("@Director", SqlDbType.NVarChar, 50),
new SqlParameter("@MnCode", SqlDbType.NVarChar, 20),
new SqlParameter("@RouterIP", SqlDbType.NVarChar, 255),
new SqlParameter("@DataIP", SqlDbType.NVarChar, 255),
new SqlParameter("@VedioIP", SqlDbType.NVarChar, 255),
new SqlParameter("@LineNo", SqlDbType.NVarChar, 50),
new SqlParameter("@Vlan", SqlDbType.NVarChar, 20),
new SqlParameter("@NetOperator", SqlDbType.NVarChar, 20),
new SqlParameter("@NetType", SqlDbType.NVarChar, 20),
new SqlParameter("@remark", SqlDbType.NVarChar, 255),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyID", SqlDbType.Int, 4),
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@AreaCode", SqlDbType.NVarChar, 15),
new SqlParameter("@PointCodeB", SqlDbType.NVarChar, 50),
new SqlParameter("@frequency", SqlDbType.Int, 4),
new SqlParameter("@latitude", SqlDbType.NVarChar, 50),
new SqlParameter("@Longitude", SqlDbType.NVarChar, 50),
new SqlParameter("@Pointaddress", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.AreaName;
parameters[1].Value = model.CompanyCode;
parameters[2].Value = model.CompanyName;
parameters[3].Value = model.PointCode;
parameters[4].Value = model.PointCode1;
parameters[5].Value = model.PointName;
parameters[6].Value = model.PointUses;
parameters[7].Value = model.是否运维;
parameters[8].Value = model.IsPatrol;
parameters[9].Value = model.是否巡检;
parameters[10].Value = model.IsContract;
parameters[11].Value = model.是否合同;
parameters[12].Value = model.PointType;
parameters[13].Value = model.Name;
parameters[14].Value = model.OutletNo;
parameters[15].Value = model.PassTime;
parameters[16].Value = model.EnvirLevel;
parameters[17].Value = model.OperatedLevel;
parameters[18].Value = model.OperatedCenter;
parameters[19].Value = model.OperatedGroup;
parameters[20].Value = model.Director;
parameters[21].Value = model.MnCode;
parameters[22].Value = model.RouterIP;
parameters[23].Value = model.DataIP;
parameters[24].Value = model.VedioIP;
parameters[25].Value = model.LineNo;
parameters[26].Value = model.Vlan;
parameters[27].Value = model.NetOperator;
parameters[28].Value = model.NetType;
parameters[29].Value = model.remark;
parameters[30].Value = model.UpdateTime;
parameters[31].Value = model.UpdatePerson;
parameters[32].Value = model.CompanyID;
parameters[33].Value = model.PointID;
parameters[34].Value = model.AreaCode;
parameters[35].Value = model.PointCodeB;
parameters[36].Value = model.frequency;
parameters[37].Value = model.latitude;
parameters[38].Value = model.Longitude;
parameters[39].Value = model.Pointaddress;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
