private void ShowInfo(int SchemeId)
{
NoName.NetShop.BLL.SuitSchemeModelBll bll = new NoName.NetShop.BLL.SuitSchemeModelBll();
NoName.NetShop.Model.SuitSchemeModel model = bll.GetModel(SchemeId);
this.lblSchemeName.Text = model.SchemeName;
this.lblCreateTime.Text = model.CreateTime.ToString();
this.lblStatus.Text = model.Status.ToString();
this.lblSchemeDesc.Text = model.SchemeDesc;
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(NoName.NetShop.Model.SuitSchemeModel model)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_ssSuitScheme_Update");
db.AddInParameter(dbCommand, "SchemeId", DbType.Int32, model.SchemeId);
db.AddInParameter(dbCommand, "SchemeName", DbType.AnsiString, model.SchemeName);
db.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, model.CreateTime);
db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
db.AddInParameter(dbCommand, "SchemeDesc", DbType.AnsiString, model.SchemeDesc);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.Model.SuitSchemeModel GetModel(int SchemeId)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_ssSuitScheme_GetModel");
db.AddInParameter(dbCommand, "SchemeId", DbType.Int32, SchemeId);
NoName.NetShop.Model.SuitSchemeModel model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtSchemeName.Text == "")
{
strErr += "SchemeName不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtCreateTime.Text))
{
strErr += "CreateTime不是时间格式！\\n";
}
if (!PageValidate.IsNumber(txtStatus.Text))
{
strErr += "Status不是数字！\\n";
}
if (this.txtSchemeDesc.Text == "")
{
strErr += "SchemeDesc不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string SchemeName = this.txtSchemeName.Text;
DateTime CreateTime = DateTime.Parse(this.txtCreateTime.Text);
int Status = int.Parse(this.txtStatus.Text);
string SchemeDesc = this.txtSchemeDesc.Text;
NoName.NetShop.Model.SuitSchemeModel model = new NoName.NetShop.Model.SuitSchemeModel();
model.SchemeName = SchemeName;
model.CreateTime = CreateTime;
model.Status = Status;
model.SchemeDesc = SchemeDesc;
NoName.NetShop.BLL.SuitSchemeModelBll bll = new NoName.NetShop.BLL.SuitSchemeModelBll();
bll.Update(model);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr="";
if(this.txtSchemeName.Text =="")
{
strErr+="SchemeName����Ϊ�գ�\\n";
}
if(!PageValidate.IsDateTime(txtCreateTime.Text))
{
strErr+="CreateTime����ʱ���ʽ��\\n";
}
if(!PageValidate.IsNumber(txtStatus.Text))
{
strErr+="Status�������֣�\\n";
}
if(this.txtSchemeDesc.Text =="")
{
strErr+="SchemeDesc����Ϊ�գ�\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
string SchemeName=this.txtSchemeName.Text;
DateTime CreateTime=DateTime.Parse(this.txtCreateTime.Text);
int Status=int.Parse(this.txtStatus.Text);
string SchemeDesc=this.txtSchemeDesc.Text;
NoName.NetShop.Model.SuitSchemeModel model=new NoName.NetShop.Model.SuitSchemeModel();
model.SchemeName=SchemeName;
model.CreateTime=CreateTime;
model.Status=Status;
model.SchemeDesc=SchemeDesc;
NoName.NetShop.BLL.SuitSchemeModelBll bll=new NoName.NetShop.BLL.SuitSchemeModelBll();
bll.Update(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Model.SuitSchemeModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.SuitSchemeModel model = new NoName.NetShop.Model.SuitSchemeModel();
object ojb;
ojb = dataReader["SchemeId"];
if (ojb != null && ojb != DBNull.Value)
{
model.SchemeId = (int)ojb;
}
model.SchemeName = dataReader["SchemeName"].ToString();
ojb = dataReader["CreateTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateTime = (DateTime)ojb;
}
ojb = dataReader["Status"];
if (ojb != null && ojb != DBNull.Value)
{
model.Status = (int)ojb;
}
model.SchemeDesc = dataReader["SchemeDesc"].ToString();
return(model);
}
/// <summary>
/// ����ʵ�������
/// </summary>
public NoName.NetShop.Model.SuitSchemeModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.SuitSchemeModel model=new NoName.NetShop.Model.SuitSchemeModel();
object ojb;
ojb = dataReader["SchemeId"];
if(ojb != null && ojb != DBNull.Value)
{
model.SchemeId=(int)ojb;
}
model.SchemeName=dataReader["SchemeName"].ToString();
ojb = dataReader["CreateTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.CreateTime=(DateTime)ojb;
}
ojb = dataReader["Status"];
if(ojb != null && ojb != DBNull.Value)
{
model.Status=(int)ojb;
}
model.SchemeDesc=dataReader["SchemeDesc"].ToString();
return model;
}
