/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.PhoneMessage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PhoneMessage set ");
strSql.Append("SoftName=@SoftName,");
strSql.Append("Brands=@Brands,");
strSql.Append("Model=@Model,");
strSql.Append("Version=@Version,");
strSql.Append("BlueToothVer=@BlueToothVer,");
strSql.Append("SDKVer=@SDKVer,");
strSql.Append("IMEI=@IMEI,");
strSql.Append("CPU=@CPU,");
strSql.Append("Memory=@Memory,");
strSql.Append("Resolution=@Resolution,");
strSql.Append("FirstLoginDate=@FirstLoginDate");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@SoftName", SqlDbType.VarChar, 100),
new SqlParameter("@Brands", SqlDbType.VarChar, 50),
new SqlParameter("@Model", SqlDbType.VarChar, 50),
new SqlParameter("@Version", SqlDbType.VarChar, 50),
new SqlParameter("@BlueToothVer", SqlDbType.VarChar, 50),
new SqlParameter("@SDKVer", SqlDbType.VarChar, 50),
new SqlParameter("@IMEI", SqlDbType.VarChar, 50),
new SqlParameter("@CPU", SqlDbType.VarChar, 50),
new SqlParameter("@Memory", SqlDbType.VarChar, 50),
new SqlParameter("@Resolution", SqlDbType.VarChar, 50),
new SqlParameter("@FirstLoginDate", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.SoftName;
parameters[1].Value = model.Brands;
parameters[2].Value = model.Model;
parameters[3].Value = model.Version;
parameters[4].Value = model.BlueToothVer;
parameters[5].Value = model.SDKVer;
parameters[6].Value = model.IMEI;
parameters[7].Value = model.CPU;
parameters[8].Value = model.Memory;
parameters[9].Value = model.Resolution;
parameters[10].Value = model.FirstLoginDate;
parameters[11].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.PhoneMessage DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.PhoneMessage model = new WebDemo.Model.WebDemo.PhoneMessage();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["SoftName"] != null)
{
model.SoftName = row["SoftName"].ToString();
}
if (row["Brands"] != null)
{
model.Brands = row["Brands"].ToString();
}
if (row["Model"] != null)
{
model.Model = row["Model"].ToString();
}
if (row["Version"] != null)
{
model.Version = row["Version"].ToString();
}
if (row["BlueToothVer"] != null)
{
model.BlueToothVer = row["BlueToothVer"].ToString();
}
if (row["SDKVer"] != null)
{
model.SDKVer = row["SDKVer"].ToString();
}
if (row["IMEI"] != null)
{
model.IMEI = row["IMEI"].ToString();
}
if (row["CPU"] != null)
{
model.CPU = row["CPU"].ToString();
}
if (row["Memory"] != null)
{
model.Memory = row["Memory"].ToString();
}
if (row["Resolution"] != null)
{
model.Resolution = row["Resolution"].ToString();
}
if (row["FirstLoginDate"] != null && row["FirstLoginDate"].ToString() != "")
{
model.FirstLoginDate = DateTime.Parse(row["FirstLoginDate"].ToString());
}
}
return(model);
}
private void ShowInfo(int ID)
{
WebDemo.BLL.WebDemo.PhoneMessage bll = new WebDemo.BLL.WebDemo.PhoneMessage();
WebDemo.Model.WebDemo.PhoneMessage model = bll.GetModel(ID);
this.lblID.Text = model.ID.ToString();
this.lblSoftName.Text = model.SoftName;
this.lblBrands.Text = model.Brands;
this.lblModel.Text = model.Model;
this.lblVersion.Text = model.Version;
this.lblBlueToothVer.Text = model.BlueToothVer;
this.lblSDKVer.Text = model.SDKVer;
this.lblIMEI.Text = model.IMEI;
this.lblCPU.Text = model.CPU;
this.lblMemory.Text = model.Memory;
this.lblResolution.Text = model.Resolution;
this.lblFirstLoginDate.Text = model.FirstLoginDate.ToString();
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.PhoneMessage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PhoneMessage(");
strSql.Append("SoftName,Brands,Model,Version,BlueToothVer,SDKVer,IMEI,CPU,Memory,Resolution,FirstLoginDate)");
strSql.Append(" values (");
strSql.Append("@SoftName,@Brands,@Model,@Version,@BlueToothVer,@SDKVer,@IMEI,@CPU,@Memory,@Resolution,@FirstLoginDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SoftName", SqlDbType.VarChar, 100),
new SqlParameter("@Brands", SqlDbType.VarChar, 50),
new SqlParameter("@Model", SqlDbType.VarChar, 50),
new SqlParameter("@Version", SqlDbType.VarChar, 50),
new SqlParameter("@BlueToothVer", SqlDbType.VarChar, 50),
new SqlParameter("@SDKVer", SqlDbType.VarChar, 50),
new SqlParameter("@IMEI", SqlDbType.VarChar, 50),
new SqlParameter("@CPU", SqlDbType.VarChar, 50),
new SqlParameter("@Memory", SqlDbType.VarChar, 50),
new SqlParameter("@Resolution", SqlDbType.VarChar, 50),
new SqlParameter("@FirstLoginDate", SqlDbType.DateTime)
};
parameters[0].Value = model.SoftName;
parameters[1].Value = model.Brands;
parameters[2].Value = model.Model;
parameters[3].Value = model.Version;
parameters[4].Value = model.BlueToothVer;
parameters[5].Value = model.SDKVer;
parameters[6].Value = model.IMEI;
parameters[7].Value = model.CPU;
parameters[8].Value = model.Memory;
parameters[9].Value = model.Resolution;
parameters[10].Value = model.FirstLoginDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.PhoneMessage GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,SoftName,Brands,Model,Version,BlueToothVer,SDKVer,IMEI,CPU,Memory,Resolution,FirstLoginDate from PhoneMessage ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
WebDemo.Model.WebDemo.PhoneMessage model = new WebDemo.Model.WebDemo.PhoneMessage();
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.txtSoftName.Text.Trim().Length == 0)
{
strErr += "SoftName不能为空！\\n";
}
if (this.txtBrands.Text.Trim().Length == 0)
{
strErr += "Brands不能为空！\\n";
}
if (this.txtModel.Text.Trim().Length == 0)
{
strErr += "Model不能为空！\\n";
}
if (this.txtVersion.Text.Trim().Length == 0)
{
strErr += "Version不能为空！\\n";
}
if (this.txtBlueToothVer.Text.Trim().Length == 0)
{
strErr += "BlueToothVer不能为空！\\n";
}
if (this.txtSDKVer.Text.Trim().Length == 0)
{
strErr += "SDKVer不能为空！\\n";
}
if (this.txtIMEI.Text.Trim().Length == 0)
{
strErr += "IMEI不能为空！\\n";
}
if (this.txtCPU.Text.Trim().Length == 0)
{
strErr += "CPU不能为空！\\n";
}
if (this.txtMemory.Text.Trim().Length == 0)
{
strErr += "Memory不能为空！\\n";
}
if (this.txtResolution.Text.Trim().Length == 0)
{
strErr += "Resolution不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtFirstLoginDate.Text))
{
strErr += "FirstLoginDate格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int ID = int.Parse(this.lblID.Text);
string SoftName = this.txtSoftName.Text;
string Brands = this.txtBrands.Text;
string Model = this.txtModel.Text;
string Version = this.txtVersion.Text;
string BlueToothVer = this.txtBlueToothVer.Text;
string SDKVer = this.txtSDKVer.Text;
string IMEI = this.txtIMEI.Text;
string CPU = this.txtCPU.Text;
string Memory = this.txtMemory.Text;
string Resolution = this.txtResolution.Text;
DateTime FirstLoginDate = DateTime.Parse(this.txtFirstLoginDate.Text);
WebDemo.Model.WebDemo.PhoneMessage model = new WebDemo.Model.WebDemo.PhoneMessage();
model.ID = ID;
model.SoftName = SoftName;
model.Brands = Brands;
model.Model = Model;
model.Version = Version;
model.BlueToothVer = BlueToothVer;
model.SDKVer = SDKVer;
model.IMEI = IMEI;
model.CPU = CPU;
model.Memory = Memory;
model.Resolution = Resolution;
model.FirstLoginDate = FirstLoginDate;
WebDemo.BLL.WebDemo.PhoneMessage bll = new WebDemo.BLL.WebDemo.PhoneMessage();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}