private void ShowInfo(int CollectorID)
{
WebDemo.BLL.WebDemo.Collectors bll = new WebDemo.BLL.WebDemo.Collectors();
WebDemo.Model.WebDemo.Collectors model = bll.GetModel(CollectorID);
this.lblCollectorID.Text = model.CollectorID.ToString();
this.txtCollectorName.Text = model.CollectorName;
this.txtCollectorAddr.Text = model.CollectorAddr;
this.txtCollectorType.Text = model.CollectorType.ToString();
this.txtDeptID.Text = model.DeptID;
this.txtPhoneNumber.Text = model.PhoneNumber;
this.txtCollOverTime.Text = model.CollOverTime.ToString();
this.txtIPNumber.Text = model.IPNumber;
this.txtPortNumber.Text = model.PortNumber.ToString();
this.txtGprsCycle.Text = model.GprsCycle.ToString();
this.txtFreezeDay.Text = model.FreezeDay.ToString();
this.txtFreezeHour.Text = model.FreezeHour.ToString();
this.txtReadDay.Text = model.ReadDay;
this.txtLoginDate.Text = model.LoginDate.ToString();
this.txtUpdateDate.Text = model.UpdateDate.ToString();
this.txtLoginIP.Text = model.LoginIP;
this.txtLoginPort.Text = model.LoginPort.ToString();
this.txtMark.Text = model.Mark.ToString();
this.txtRemark.Text = model.Remark;
this.txtCollectorVer.Text = model.CollectorVer;
this.txtCollectorModel.Text = model.CollectorModel;
this.txtCollectorAPN.Text = model.CollectorAPN;
this.txtIsServerMode.Text = model.IsServerMode.ToString();
this.txtWorkTime.Text = model.WorkTime;
this.txtNetWorkTime.Text = model.NetWorkTime;
this.txtFactoryCode.Text = model.FactoryCode;
this.txtFramesType.Text = model.FramesType.ToString();
this.txtMeterAddrFormat.Text = model.MeterAddrFormat.ToString();
this.txtGprsPhone.Text = model.GprsPhone;
this.txtExpireTime.Text = model.ExpireTime;
this.txtWorkMode.Text = model.WorkMode.ToString();
this.txtLng.Text = model.Lng.ToString();
this.txtLat.Text = model.Lat.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.Collectors GetModel(int CollectorID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CollectorID,CollectorName,CollectorAddr,CollectorType,DeptID,PhoneNumber,CollOverTime,IPNumber,PortNumber,GprsCycle,FreezeDay,FreezeHour,ReadDay,LoginDate,UpdateDate,LoginIP,LoginPort,Mark,Remark,CollectorVer,CollectorModel,CollectorAPN,IsServerMode,WorkTime,NetWorkTime,FactoryCode,FramesType,MeterAddrFormat,GprsPhone,ExpireTime,WorkMode,Lng,Lat from Collectors ");
strSql.Append(" where CollectorID=@CollectorID ");
SqlParameter[] parameters =
{
new SqlParameter("@CollectorID", SqlDbType.Int, 4)
};
parameters[0].Value = CollectorID;
WebDemo.Model.WebDemo.Collectors model = new WebDemo.Model.WebDemo.Collectors();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtCollectorName.Text.Trim().Length == 0)
{
strErr += "集中器名称不能为空！\\n";
}
if (this.txtCollectorAddr.Text.Trim().Length == 0)
{
strErr += "集中器地址不能为空！\\n";
}
if (!PageValidate.IsNumber(txtCollectorType.Text))
{
strErr += "集中器类型(1-电话线方式；2格式错误！\\n";
}
if (this.txtDeptID.Text.Trim().Length == 0)
{
strErr += "部门编号不能为空！\\n";
}
if (this.txtPhoneNumber.Text.Trim().Length == 0)
{
strErr += "电话号码(电话线方式时使用)不能为空！\\n";
}
if (!PageValidate.IsNumber(txtCollOverTime.Text))
{
strErr += "超时时间格式错误！\\n";
}
if (this.txtIPNumber.Text.Trim().Length == 0)
{
strErr += "IP地址(以太网方式时使用)不能为空！\\n";
}
if (!PageValidate.IsNumber(txtPortNumber.Text))
{
strErr += "端口号(以太网方式时使用)格式错误！\\n";
}
if (!PageValidate.IsNumber(txtGprsCycle.Text))
{
strErr += "Gprs心跳周期格式错误！\\n";
}
if (!PageValidate.IsNumber(txtFreezeDay.Text))
{
strErr += "冻结日格式错误！\\n";
}
if (!PageValidate.IsNumber(txtFreezeHour.Text))
{
strErr += "冻结时格式错误！\\n";
}
if (this.txtReadDay.Text.Trim().Length == 0)
{
strErr += "抄表日不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtLoginDate.Text))
{
strErr += "登录时间格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtUpdateDate.Text))
{
strErr += "更新时间格式错误！\\n";
}
if (this.txtLoginIP.Text.Trim().Length == 0)
{
strErr += "登录IP不能为空！\\n";
}
if (!PageValidate.IsNumber(txtLoginPort.Text))
{
strErr += "登录端口格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMark.Text))
{
strErr += "终端状态(0-离线；1-在线)格式错误！\\n";
}
if (this.txtRemark.Text.Trim().Length == 0)
{
strErr += "备注信息不能为空！\\n";
}
if (this.txtCollectorVer.Text.Trim().Length == 0)
{
strErr += "集中器版本不能为空！\\n";
}
if (this.txtCollectorModel.Text.Trim().Length == 0)
{
strErr += "集中器型号不能为空！\\n";
}
if (this.txtCollectorAPN.Text.Trim().Length == 0)
{
strErr += "CollectorAPN不能为空！\\n";
}
if (!PageValidate.IsNumber(txtIsServerMode.Text))
{
strErr += "IsServerMode格式错误！\\n";
}
if (this.txtWorkTime.Text.Trim().Length == 0)
{
strErr += "WorkTime不能为空！\\n";
}
if (this.txtNetWorkTime.Text.Trim().Length == 0)
{
strErr += "NetWorkTime不能为空！\\n";
}
if (this.txtFactoryCode.Text.Trim().Length == 0)
{
strErr += "FactoryCode不能为空！\\n";
}
if (!PageValidate.IsNumber(txtFramesType.Text))
{
strErr += "FramesType格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMeterAddrFormat.Text))
{
strErr += "MeterAddrFormat格式错误！\\n";
}
if (this.txtGprsPhone.Text.Trim().Length == 0)
{
strErr += "GprsPhone不能为空！\\n";
}
if (this.txtExpireTime.Text.Trim().Length == 0)
{
strErr += "ExpireTime不能为空！\\n";
}
if (!PageValidate.IsNumber(txtWorkMode.Text))
{
strErr += "WorkMode格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtLng.Text))
{
strErr += "Lng格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtLat.Text))
{
strErr += "Lat格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int CollectorID = int.Parse(this.lblCollectorID.Text);
string CollectorName = this.txtCollectorName.Text;
string CollectorAddr = this.txtCollectorAddr.Text;
int CollectorType = int.Parse(this.txtCollectorType.Text);
string DeptID = this.txtDeptID.Text;
string PhoneNumber = this.txtPhoneNumber.Text;
int CollOverTime = int.Parse(this.txtCollOverTime.Text);
string IPNumber = this.txtIPNumber.Text;
int PortNumber = int.Parse(this.txtPortNumber.Text);
int GprsCycle = int.Parse(this.txtGprsCycle.Text);
int FreezeDay = int.Parse(this.txtFreezeDay.Text);
int FreezeHour = int.Parse(this.txtFreezeHour.Text);
string ReadDay = this.txtReadDay.Text;
DateTime LoginDate = DateTime.Parse(this.txtLoginDate.Text);
DateTime UpdateDate = DateTime.Parse(this.txtUpdateDate.Text);
string LoginIP = this.txtLoginIP.Text;
int LoginPort = int.Parse(this.txtLoginPort.Text);
int Mark = int.Parse(this.txtMark.Text);
string Remark = this.txtRemark.Text;
string CollectorVer = this.txtCollectorVer.Text;
string CollectorModel = this.txtCollectorModel.Text;
string CollectorAPN = this.txtCollectorAPN.Text;
int IsServerMode = int.Parse(this.txtIsServerMode.Text);
string WorkTime = this.txtWorkTime.Text;
string NetWorkTime = this.txtNetWorkTime.Text;
string FactoryCode = this.txtFactoryCode.Text;
int FramesType = int.Parse(this.txtFramesType.Text);
int MeterAddrFormat = int.Parse(this.txtMeterAddrFormat.Text);
string GprsPhone = this.txtGprsPhone.Text;
string ExpireTime = this.txtExpireTime.Text;
int WorkMode = int.Parse(this.txtWorkMode.Text);
decimal Lng = decimal.Parse(this.txtLng.Text);
decimal Lat = decimal.Parse(this.txtLat.Text);
WebDemo.Model.WebDemo.Collectors model = new WebDemo.Model.WebDemo.Collectors();
model.CollectorID = CollectorID;
model.CollectorName = CollectorName;
model.CollectorAddr = CollectorAddr;
model.CollectorType = CollectorType;
model.DeptID = DeptID;
model.PhoneNumber = PhoneNumber;
model.CollOverTime = CollOverTime;
model.IPNumber = IPNumber;
model.PortNumber = PortNumber;
model.GprsCycle = GprsCycle;
model.FreezeDay = FreezeDay;
model.FreezeHour = FreezeHour;
model.ReadDay = ReadDay;
model.LoginDate = LoginDate;
model.UpdateDate = UpdateDate;
model.LoginIP = LoginIP;
model.LoginPort = LoginPort;
model.Mark = Mark;
model.Remark = Remark;
model.CollectorVer = CollectorVer;
model.CollectorModel = CollectorModel;
model.CollectorAPN = CollectorAPN;
model.IsServerMode = IsServerMode;
model.WorkTime = WorkTime;
model.NetWorkTime = NetWorkTime;
model.FactoryCode = FactoryCode;
model.FramesType = FramesType;
model.MeterAddrFormat = MeterAddrFormat;
model.GprsPhone = GprsPhone;
model.ExpireTime = ExpireTime;
model.WorkMode = WorkMode;
model.Lng = Lng;
model.Lat = Lat;
WebDemo.BLL.WebDemo.Collectors bll = new WebDemo.BLL.WebDemo.Collectors();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WebDemo.Model.WebDemo.Collectors model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Collectors(");
strSql.Append("CollectorID,CollectorName,CollectorAddr,CollectorType,DeptID,PhoneNumber,CollOverTime,IPNumber,PortNumber,GprsCycle,FreezeDay,FreezeHour,ReadDay,LoginDate,UpdateDate,LoginIP,LoginPort,Mark,Remark,CollectorVer,CollectorModel,CollectorAPN,IsServerMode,WorkTime,NetWorkTime,FactoryCode,FramesType,MeterAddrFormat,GprsPhone,ExpireTime,WorkMode,Lng,Lat)");
strSql.Append(" values (");
strSql.Append("@CollectorID,@CollectorName,@CollectorAddr,@CollectorType,@DeptID,@PhoneNumber,@CollOverTime,@IPNumber,@PortNumber,@GprsCycle,@FreezeDay,@FreezeHour,@ReadDay,@LoginDate,@UpdateDate,@LoginIP,@LoginPort,@Mark,@Remark,@CollectorVer,@CollectorModel,@CollectorAPN,@IsServerMode,@WorkTime,@NetWorkTime,@FactoryCode,@FramesType,@MeterAddrFormat,@GprsPhone,@ExpireTime,@WorkMode,@Lng,@Lat)");
SqlParameter[] parameters =
{
new SqlParameter("@CollectorID", SqlDbType.Int, 4),
new SqlParameter("@CollectorName", SqlDbType.VarChar, 50),
new SqlParameter("@CollectorAddr", SqlDbType.VarChar, 10),
new SqlParameter("@CollectorType", SqlDbType.Int, 4),
new SqlParameter("@DeptID", SqlDbType.VarChar, 50),
new SqlParameter("@PhoneNumber", SqlDbType.VarChar, 50),
new SqlParameter("@CollOverTime", SqlDbType.Int, 4),
new SqlParameter("@IPNumber", SqlDbType.VarChar, 50),
new SqlParameter("@PortNumber", SqlDbType.Int, 4),
new SqlParameter("@GprsCycle", SqlDbType.Int, 4),
new SqlParameter("@FreezeDay", SqlDbType.Int, 4),
new SqlParameter("@FreezeHour", SqlDbType.Int, 4),
new SqlParameter("@ReadDay", SqlDbType.VarChar, 10),
new SqlParameter("@LoginDate", SqlDbType.DateTime),
new SqlParameter("@UpdateDate", SqlDbType.DateTime),
new SqlParameter("@LoginIP", SqlDbType.VarChar, 50),
new SqlParameter("@LoginPort", SqlDbType.Int, 4),
new SqlParameter("@Mark", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 500),
new SqlParameter("@CollectorVer", SqlDbType.VarChar, 50),
new SqlParameter("@CollectorModel", SqlDbType.VarChar, 50),
new SqlParameter("@CollectorAPN", SqlDbType.VarChar, 102),
new SqlParameter("@IsServerMode", SqlDbType.Int, 4),
new SqlParameter("@WorkTime", SqlDbType.VarChar, 24),
new SqlParameter("@NetWorkTime", SqlDbType.VarChar, 24),
new SqlParameter("@FactoryCode", SqlDbType.VarChar, 50),
new SqlParameter("@FramesType", SqlDbType.Int, 4),
new SqlParameter("@MeterAddrFormat", SqlDbType.Int, 4),
new SqlParameter("@GprsPhone", SqlDbType.VarChar, 20),
new SqlParameter("@ExpireTime", SqlDbType.VarChar, 10),
new SqlParameter("@WorkMode", SqlDbType.TinyInt, 1),
new SqlParameter("@Lng", SqlDbType.Decimal, 9),
new SqlParameter("@Lat", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.CollectorID;
parameters[1].Value = model.CollectorName;
parameters[2].Value = model.CollectorAddr;
parameters[3].Value = model.CollectorType;
parameters[4].Value = model.DeptID;
parameters[5].Value = model.PhoneNumber;
parameters[6].Value = model.CollOverTime;
parameters[7].Value = model.IPNumber;
parameters[8].Value = model.PortNumber;
parameters[9].Value = model.GprsCycle;
parameters[10].Value = model.FreezeDay;
parameters[11].Value = model.FreezeHour;
parameters[12].Value = model.ReadDay;
parameters[13].Value = model.LoginDate;
parameters[14].Value = model.UpdateDate;
parameters[15].Value = model.LoginIP;
parameters[16].Value = model.LoginPort;
parameters[17].Value = model.Mark;
parameters[18].Value = model.Remark;
parameters[19].Value = model.CollectorVer;
parameters[20].Value = model.CollectorModel;
parameters[21].Value = model.CollectorAPN;
parameters[22].Value = model.IsServerMode;
parameters[23].Value = model.WorkTime;
parameters[24].Value = model.NetWorkTime;
parameters[25].Value = model.FactoryCode;
parameters[26].Value = model.FramesType;
parameters[27].Value = model.MeterAddrFormat;
parameters[28].Value = model.GprsPhone;
parameters[29].Value = model.ExpireTime;
parameters[30].Value = model.WorkMode;
parameters[31].Value = model.Lng;
parameters[32].Value = model.Lat;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.Collectors DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.Collectors model = new WebDemo.Model.WebDemo.Collectors();
if (row != null)
{
if (row["CollectorID"] != null && row["CollectorID"].ToString() != "")
{
model.CollectorID = int.Parse(row["CollectorID"].ToString());
}
if (row["CollectorName"] != null)
{
model.CollectorName = row["CollectorName"].ToString();
}
if (row["CollectorAddr"] != null)
{
model.CollectorAddr = row["CollectorAddr"].ToString();
}
if (row["CollectorType"] != null && row["CollectorType"].ToString() != "")
{
model.CollectorType = int.Parse(row["CollectorType"].ToString());
}
if (row["DeptID"] != null)
{
model.DeptID = row["DeptID"].ToString();
}
if (row["PhoneNumber"] != null)
{
model.PhoneNumber = row["PhoneNumber"].ToString();
}
if (row["CollOverTime"] != null && row["CollOverTime"].ToString() != "")
{
model.CollOverTime = int.Parse(row["CollOverTime"].ToString());
}
if (row["IPNumber"] != null)
{
model.IPNumber = row["IPNumber"].ToString();
}
if (row["PortNumber"] != null && row["PortNumber"].ToString() != "")
{
model.PortNumber = int.Parse(row["PortNumber"].ToString());
}
if (row["GprsCycle"] != null && row["GprsCycle"].ToString() != "")
{
model.GprsCycle = int.Parse(row["GprsCycle"].ToString());
}
if (row["FreezeDay"] != null && row["FreezeDay"].ToString() != "")
{
model.FreezeDay = int.Parse(row["FreezeDay"].ToString());
}
if (row["FreezeHour"] != null && row["FreezeHour"].ToString() != "")
{
model.FreezeHour = int.Parse(row["FreezeHour"].ToString());
}
if (row["ReadDay"] != null)
{
model.ReadDay = row["ReadDay"].ToString();
}
if (row["LoginDate"] != null && row["LoginDate"].ToString() != "")
{
model.LoginDate = DateTime.Parse(row["LoginDate"].ToString());
}
if (row["UpdateDate"] != null && row["UpdateDate"].ToString() != "")
{
model.UpdateDate = DateTime.Parse(row["UpdateDate"].ToString());
}
if (row["LoginIP"] != null)
{
model.LoginIP = row["LoginIP"].ToString();
}
if (row["LoginPort"] != null && row["LoginPort"].ToString() != "")
{
model.LoginPort = int.Parse(row["LoginPort"].ToString());
}
if (row["Mark"] != null && row["Mark"].ToString() != "")
{
model.Mark = int.Parse(row["Mark"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["CollectorVer"] != null)
{
model.CollectorVer = row["CollectorVer"].ToString();
}
if (row["CollectorModel"] != null)
{
model.CollectorModel = row["CollectorModel"].ToString();
}
if (row["CollectorAPN"] != null)
{
model.CollectorAPN = row["CollectorAPN"].ToString();
}
if (row["IsServerMode"] != null && row["IsServerMode"].ToString() != "")
{
model.IsServerMode = int.Parse(row["IsServerMode"].ToString());
}
if (row["WorkTime"] != null)
{
model.WorkTime = row["WorkTime"].ToString();
}
if (row["NetWorkTime"] != null)
{
model.NetWorkTime = row["NetWorkTime"].ToString();
}
if (row["FactoryCode"] != null)
{
model.FactoryCode = row["FactoryCode"].ToString();
}
if (row["FramesType"] != null && row["FramesType"].ToString() != "")
{
model.FramesType = int.Parse(row["FramesType"].ToString());
}
if (row["MeterAddrFormat"] != null && row["MeterAddrFormat"].ToString() != "")
{
model.MeterAddrFormat = int.Parse(row["MeterAddrFormat"].ToString());
}
if (row["GprsPhone"] != null)
{
model.GprsPhone = row["GprsPhone"].ToString();
}
if (row["ExpireTime"] != null)
{
model.ExpireTime = row["ExpireTime"].ToString();
}
if (row["WorkMode"] != null && row["WorkMode"].ToString() != "")
{
model.WorkMode = int.Parse(row["WorkMode"].ToString());
}
if (row["Lng"] != null && row["Lng"].ToString() != "")
{
model.Lng = decimal.Parse(row["Lng"].ToString());
}
if (row["Lat"] != null && row["Lat"].ToString() != "")
{
model.Lat = decimal.Parse(row["Lat"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.Collectors model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Collectors set ");
strSql.Append("CollectorName=@CollectorName,");
strSql.Append("CollectorAddr=@CollectorAddr,");
strSql.Append("CollectorType=@CollectorType,");
strSql.Append("DeptID=@DeptID,");
strSql.Append("PhoneNumber=@PhoneNumber,");
strSql.Append("CollOverTime=@CollOverTime,");
strSql.Append("IPNumber=@IPNumber,");
strSql.Append("PortNumber=@PortNumber,");
strSql.Append("GprsCycle=@GprsCycle,");
strSql.Append("FreezeDay=@FreezeDay,");
strSql.Append("FreezeHour=@FreezeHour,");
strSql.Append("ReadDay=@ReadDay,");
strSql.Append("LoginDate=@LoginDate,");
strSql.Append("UpdateDate=@UpdateDate,");
strSql.Append("LoginIP=@LoginIP,");
strSql.Append("LoginPort=@LoginPort,");
strSql.Append("Mark=@Mark,");
strSql.Append("Remark=@Remark,");
strSql.Append("CollectorVer=@CollectorVer,");
strSql.Append("CollectorModel=@CollectorModel,");
strSql.Append("CollectorAPN=@CollectorAPN,");
strSql.Append("IsServerMode=@IsServerMode,");
strSql.Append("WorkTime=@WorkTime,");
strSql.Append("NetWorkTime=@NetWorkTime,");
strSql.Append("FactoryCode=@FactoryCode,");
strSql.Append("FramesType=@FramesType,");
strSql.Append("MeterAddrFormat=@MeterAddrFormat,");
strSql.Append("GprsPhone=@GprsPhone,");
strSql.Append("ExpireTime=@ExpireTime,");
strSql.Append("WorkMode=@WorkMode,");
strSql.Append("Lng=@Lng,");
strSql.Append("Lat=@Lat");
strSql.Append(" where CollectorID=@CollectorID ");
SqlParameter[] parameters =
{
new SqlParameter("@CollectorName", SqlDbType.VarChar, 50),
new SqlParameter("@CollectorAddr", SqlDbType.VarChar, 10),
new SqlParameter("@CollectorType", SqlDbType.Int, 4),
new SqlParameter("@DeptID", SqlDbType.VarChar, 50),
new SqlParameter("@PhoneNumber", SqlDbType.VarChar, 50),
new SqlParameter("@CollOverTime", SqlDbType.Int, 4),
new SqlParameter("@IPNumber", SqlDbType.VarChar, 50),
new SqlParameter("@PortNumber", SqlDbType.Int, 4),
new SqlParameter("@GprsCycle", SqlDbType.Int, 4),
new SqlParameter("@FreezeDay", SqlDbType.Int, 4),
new SqlParameter("@FreezeHour", SqlDbType.Int, 4),
new SqlParameter("@ReadDay", SqlDbType.VarChar, 10),
new SqlParameter("@LoginDate", SqlDbType.DateTime),
new SqlParameter("@UpdateDate", SqlDbType.DateTime),
new SqlParameter("@LoginIP", SqlDbType.VarChar, 50),
new SqlParameter("@LoginPort", SqlDbType.Int, 4),
new SqlParameter("@Mark", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 500),
new SqlParameter("@CollectorVer", SqlDbType.VarChar, 50),
new SqlParameter("@CollectorModel", SqlDbType.VarChar, 50),
new SqlParameter("@CollectorAPN", SqlDbType.VarChar, 102),
new SqlParameter("@IsServerMode", SqlDbType.Int, 4),
new SqlParameter("@WorkTime", SqlDbType.VarChar, 24),
new SqlParameter("@NetWorkTime", SqlDbType.VarChar, 24),
new SqlParameter("@FactoryCode", SqlDbType.VarChar, 50),
new SqlParameter("@FramesType", SqlDbType.Int, 4),
new SqlParameter("@MeterAddrFormat", SqlDbType.Int, 4),
new SqlParameter("@GprsPhone", SqlDbType.VarChar, 20),
new SqlParameter("@ExpireTime", SqlDbType.VarChar, 10),
new SqlParameter("@WorkMode", SqlDbType.TinyInt, 1),
new SqlParameter("@Lng", SqlDbType.Decimal, 9),
new SqlParameter("@Lat", SqlDbType.Decimal, 9),
new SqlParameter("@CollectorID", SqlDbType.Int, 4)
};
parameters[0].Value = model.CollectorName;
parameters[1].Value = model.CollectorAddr;
parameters[2].Value = model.CollectorType;
parameters[3].Value = model.DeptID;
parameters[4].Value = model.PhoneNumber;
parameters[5].Value = model.CollOverTime;
parameters[6].Value = model.IPNumber;
parameters[7].Value = model.PortNumber;
parameters[8].Value = model.GprsCycle;
parameters[9].Value = model.FreezeDay;
parameters[10].Value = model.FreezeHour;
parameters[11].Value = model.ReadDay;
parameters[12].Value = model.LoginDate;
parameters[13].Value = model.UpdateDate;
parameters[14].Value = model.LoginIP;
parameters[15].Value = model.LoginPort;
parameters[16].Value = model.Mark;
parameters[17].Value = model.Remark;
parameters[18].Value = model.CollectorVer;
parameters[19].Value = model.CollectorModel;
parameters[20].Value = model.CollectorAPN;
parameters[21].Value = model.IsServerMode;
parameters[22].Value = model.WorkTime;
parameters[23].Value = model.NetWorkTime;
parameters[24].Value = model.FactoryCode;
parameters[25].Value = model.FramesType;
parameters[26].Value = model.MeterAddrFormat;
parameters[27].Value = model.GprsPhone;
parameters[28].Value = model.ExpireTime;
parameters[29].Value = model.WorkMode;
parameters[30].Value = model.Lng;
parameters[31].Value = model.Lat;
parameters[32].Value = model.CollectorID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
