/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.V_StationIp GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 AreaCode,AreaName,CompanyCode,companyname,PointCode,PointName,envirlevel,operatedlevel,Name,MnCode,RouterIP,DataIP,VedioIP,LineNo,Vlan,NetOperator,NetType,是否运维,是否合同,是否巡检 from V_StationIp ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Maticsoft.Model.V_StationIp model = new Maticsoft.Model.V_StationIp();
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_StationIp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into V_StationIp(");
strSql.Append("AreaCode,AreaName,CompanyCode,companyname,PointCode,PointName,envirlevel,operatedlevel,Name,MnCode,RouterIP,DataIP,VedioIP,LineNo,Vlan,NetOperator,NetType,是否运维,是否合同,是否巡检)");
strSql.Append(" values (");
strSql.Append("@AreaCode,@AreaName,@CompanyCode,@companyname,@PointCode,@PointName,@envirlevel,@operatedlevel,@Name,@MnCode,@RouterIP,@DataIP,@VedioIP,@LineNo,@Vlan,@NetOperator,@NetType,@是否运维,@是否合同,@是否巡检)");
SqlParameter[] parameters =
{
new SqlParameter("@AreaCode", SqlDbType.NVarChar, 15),
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 20),
new SqlParameter("@companyname", SqlDbType.NVarChar, 255),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@envirlevel", SqlDbType.NVarChar, 50),
new SqlParameter("@operatedlevel", SqlDbType.NVarChar, 20),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
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("@是否运维", SqlDbType.VarChar, 4),
new SqlParameter("@是否合同", SqlDbType.VarChar, 2),
new SqlParameter("@是否巡检", SqlDbType.VarChar, 6)
};
parameters[0].Value = model.AreaCode;
parameters[1].Value = model.AreaName;
parameters[2].Value = model.CompanyCode;
parameters[3].Value = model.companyname;
parameters[4].Value = model.PointCode;
parameters[5].Value = model.PointName;
parameters[6].Value = model.envirlevel;
parameters[7].Value = model.operatedlevel;
parameters[8].Value = model.Name;
parameters[9].Value = model.MnCode;
parameters[10].Value = model.RouterIP;
parameters[11].Value = model.DataIP;
parameters[12].Value = model.VedioIP;
parameters[13].Value = model.LineNo;
parameters[14].Value = model.Vlan;
parameters[15].Value = model.NetOperator;
parameters[16].Value = model.NetType;
parameters[17].Value = model.是否运维;
parameters[18].Value = model.是否合同;
parameters[19].Value = model.是否巡检;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.V_StationIp DataRowToModel(DataRow row)
{
Maticsoft.Model.V_StationIp model = new Maticsoft.Model.V_StationIp();
if (row != null)
{
if (row["AreaCode"] != null)
{
model.AreaCode = row["AreaCode"].ToString();
}
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["PointName"] != null)
{
model.PointName = row["PointName"].ToString();
}
if (row["envirlevel"] != null)
{
model.envirlevel = row["envirlevel"].ToString();
}
if (row["operatedlevel"] != null)
{
model.operatedlevel = row["operatedlevel"].ToString();
}
if (row["Name"] != null)
{
model.Name = row["Name"].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["是否运维"] != null)
{
model.是否运维 = row["是否运维"].ToString();
}
if (row["是否合同"] != null)
{
model.是否合同 = row["是否合同"].ToString();
}
if (row["是否巡检"] != null)
{
model.是否巡检 = row["是否巡检"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.V_StationIp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update V_StationIp set ");
strSql.Append("AreaCode=@AreaCode,");
strSql.Append("AreaName=@AreaName,");
strSql.Append("CompanyCode=@CompanyCode,");
strSql.Append("companyname=@companyname,");
strSql.Append("PointCode=@PointCode,");
strSql.Append("PointName=@PointName,");
strSql.Append("envirlevel=@envirlevel,");
strSql.Append("operatedlevel=@operatedlevel,");
strSql.Append("Name=@Name,");
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("是否运维=@是否运维,");
strSql.Append("是否合同=@是否合同,");
strSql.Append("是否巡检=@是否巡检");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@AreaCode", SqlDbType.NVarChar, 15),
new SqlParameter("@AreaName", SqlDbType.NVarChar, 255),
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 20),
new SqlParameter("@companyname", SqlDbType.NVarChar, 255),
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20),
new SqlParameter("@PointName", SqlDbType.NVarChar, 255),
new SqlParameter("@envirlevel", SqlDbType.NVarChar, 50),
new SqlParameter("@operatedlevel", SqlDbType.NVarChar, 20),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
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("@是否运维", SqlDbType.VarChar, 4),
new SqlParameter("@是否合同", SqlDbType.VarChar, 2),
new SqlParameter("@是否巡检", SqlDbType.VarChar, 6)
};
parameters[0].Value = model.AreaCode;
parameters[1].Value = model.AreaName;
parameters[2].Value = model.CompanyCode;
parameters[3].Value = model.companyname;
parameters[4].Value = model.PointCode;
parameters[5].Value = model.PointName;
parameters[6].Value = model.envirlevel;
parameters[7].Value = model.operatedlevel;
parameters[8].Value = model.Name;
parameters[9].Value = model.MnCode;
parameters[10].Value = model.RouterIP;
parameters[11].Value = model.DataIP;
parameters[12].Value = model.VedioIP;
parameters[13].Value = model.LineNo;
parameters[14].Value = model.Vlan;
parameters[15].Value = model.NetOperator;
parameters[16].Value = model.NetType;
parameters[17].Value = model.是否运维;
parameters[18].Value = model.是否合同;
parameters[19].Value = model.是否巡检;
int rows = DbBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
