/// <summary>
/// ����һ������
/// </summary>
public void Add(BrandModel model)
{
DbCommand dbCommand = dbw.GetStoredProcCommand("UP_pdBrand_ADD");
dbw.AddInParameter(dbCommand, "BrandId", DbType.Int32, model.BrandId);
dbw.AddInParameter(dbCommand, "BrandName", DbType.AnsiString, model.BrandName);
dbw.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId);
dbw.AddInParameter(dbCommand, "CatePath", DbType.AnsiString, model.CatePath);
dbw.AddInParameter(dbCommand, "BrandLogo", DbType.AnsiString, model.BrandLogo);
dbw.AddInParameter(dbCommand, "Brief", DbType.AnsiString, model.Brief);
dbw.AddInParameter(dbCommand, "showorder", DbType.Int32, model.ShowOrder);
dbw.AddInParameter(dbCommand, "pinyinname", DbType.String, model.PinYinName);
dbw.ExecuteNonQuery(dbCommand);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtBrandName.Text == "")
{
strErr += "Ʒ�����Ʋ���Ϊ�գ�\\n";
}
if (this.fulBrandLogo.FileName == "")
{
strErr += "Ʒ�Ʊ�־����Ϊ�գ�\\n";
}
if (this.txtBrief.Text == "")
{
strErr += "��Ҫ���ܲ���Ϊ�գ�\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
if (bll.Exists(txtBrandName.Text))
{
MessageBox.Show(this,"��Ʒ���Ѵ���");
return;
}
BrandModel model = new BrandModel();
model.BrandId = CommDataHelper.GetNewSerialNum("pd");
model.BrandName = txtBrandName.Text;
model.BrandLogo = UploadBrandLogo(model.BrandId, fulBrandLogo);
model.Brief = txtBrief.Text;
model.ShowOrder = model.BrandId;
bll.Add(model);
Response.Redirect("List.aspx");
}
private BrandModel GetModel(DataRow row)
{
BrandModel model = new BrandModel();
model.BrandId = int.Parse(row["BrandId"].ToString());
model.BrandName = row["BrandName"].ToString();
model.CateId = int.Parse(row["CateId"].ToString());
model.CatePath = row["CatePath"].ToString();
model.BrandLogo = row["BrandLogo"].ToString();
model.Brief = row["Brief"].ToString();
model.ShowOrder = int.Parse(row["showorder"].ToString());
return model;
}
/// <summary>
/// ����ʵ�������
/// </summary>
public BrandModel ReaderBind(IDataReader dataReader)
{
BrandModel model=new BrandModel();
object ojb;
ojb = dataReader["BrandId"];
if(ojb != null && ojb != DBNull.Value)
{
model.BrandId=(int)ojb;
}
model.BrandName=dataReader["BrandName"].ToString();
ojb = dataReader["CateId"];
if(ojb != null && ojb != DBNull.Value)
{
model.CateId=(int)ojb;
}
model.CatePath=dataReader["CatePath"].ToString();
model.BrandLogo=dataReader["BrandLogo"].ToString();
model.Brief=dataReader["Brief"].ToString();
model.ShowOrder = int.Parse(dataReader["showorder"].ToString());
return model;
}
public bool RawExists(string BrandName,out BrandModel model)
{
DbCommand Command = dbr.GetSqlStringCommand("select top 1 * from pdbrand where brandname like @brandname");
dbr.AddInParameter(Command,"@brandname",DbType.String, "%" + BrandName + "%");
DataTable dt = dbr.ExecuteDataSet(Command).Tables[0];
if (dt.Rows.Count > 0)
{
model = GetModel(dt.Rows[0]);
return true;
}
else
{
model = null;
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(BrandModel model)
{
dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(BrandModel model)
{
dal.Update(model);
}
public bool RawExists(string BrandName, out BrandModel model)
{
return dal.RawExists(BrandName,out model);
}
/// <summary>
/// ��������б�
/// </summary>
public List<BrandModel> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere, String.Empty);
List<BrandModel> modelList = new List<BrandModel>();
int rowsCount = ds.Tables[0].Rows.Count;
if (rowsCount > 0)
{
BrandModel model;
for (int n = 0; n < rowsCount; n++)
{
model = new BrandModel();
if(ds.Tables[0].Rows[n]["BrandId"].ToString()!="")
{
model.BrandId=int.Parse(ds.Tables[0].Rows[n]["BrandId"].ToString());
}
model.BrandName=ds.Tables[0].Rows[n]["BrandName"].ToString();
if(ds.Tables[0].Rows[n]["CateId"].ToString()!="")
{
model.CateId=int.Parse(ds.Tables[0].Rows[n]["CateId"].ToString());
}
model.CatePath=ds.Tables[0].Rows[n]["CatePath"].ToString();
model.BrandLogo=ds.Tables[0].Rows[n]["BrandLogo"].ToString();
model.Brief=ds.Tables[0].Rows[n]["Brief"].ToString();
modelList.Add(model);
}
}
return modelList;
}