public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtfeedbackID.Text))
{
strErr += "feedbackID格式错误！\\n";
}
if (this.txtadminName.Text.Trim().Length == 0)
{
strErr += "adminName不能为空！\\n";
}
if (this.txtdistributor.Text.Trim().Length == 0)
{
strErr += "distributor不能为空！\\n";
}
if (this.txtdescription.Text.Trim().Length == 0)
{
strErr += "description不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtdistributionTime.Text))
{
strErr += "distributionTime格式错误！\\n";
}
if (this.txtstate.Text.Trim().Length == 0)
{
strErr += "state不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int distributionID = int.Parse(this.lbldistributionID.Text);
int feedbackID = int.Parse(this.txtfeedbackID.Text);
string adminName = this.txtadminName.Text;
string distributor = this.txtdistributor.Text;
string description = this.txtdescription.Text;
DateTime distributionTime = DateTime.Parse(this.txtdistributionTime.Text);
string state = this.txtstate.Text;
UFB.Model.Distribution model = new UFB.Model.Distribution();
model.distributionID = distributionID;
model.feedbackID = feedbackID;
model.adminName = adminName;
model.distributor = distributor;
model.description = description;
model.distributionTime = distributionTime;
model.state = state;
UFB.BLL.DistributionManager bll = new UFB.BLL.DistributionManager();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
private void ShowInfo(int distributionID)
{
UFB.BLL.DistributionManager bll = new UFB.BLL.DistributionManager();
UFB.Model.Distribution model = bll.GetModel(distributionID);
this.lbldistributionID.Text = model.distributionID.ToString();
this.txtfeedbackID.Text = model.feedbackID.ToString();
this.txtadminName.Text = model.adminName;
this.txtdistributor.Text = model.distributor;
this.txtdescription.Text = model.description;
this.txtdistributionTime.Text = model.distributionTime.ToString();
this.txtstate.Text = model.state;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(UFB.Model.Distribution model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Distribution set ");
strSql.Append("feedbackID=@feedbackID,");
strSql.Append("adminName=@adminName,");
strSql.Append("distributor=@distributor,");
strSql.Append("description=@description,");
strSql.Append("distributionTime=@distributionTime,");
strSql.Append("state=@state");
strSql.Append(" where distributionID=@distributionID");
SqlParameter[] parameters =
{
new SqlParameter("@feedbackID", SqlDbType.Int, 4),
new SqlParameter("@adminName", SqlDbType.VarChar, 64),
new SqlParameter("@distributor", SqlDbType.VarChar, 64),
new SqlParameter("@description", SqlDbType.VarChar, 128),
new SqlParameter("@distributionTime", SqlDbType.SmallDateTime),
new SqlParameter("@state", SqlDbType.VarChar, 16),
new SqlParameter("@distributionID", SqlDbType.Int, 4)
};
parameters[0].Value = model.feedbackID;
parameters[1].Value = model.adminName;
parameters[2].Value = model.distributor;
parameters[3].Value = model.description;
parameters[4].Value = model.distributionTime;
parameters[5].Value = model.state;
parameters[6].Value = model.distributionID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(UFB.Model.Distribution model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Distribution(");
strSql.Append("feedbackID,adminName,distributor,description,distributionTime,state)");
strSql.Append(" values (");
strSql.Append("@feedbackID,@adminName,@distributor,@description,@distributionTime,@state)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@feedbackID", SqlDbType.Int, 4),
new SqlParameter("@adminName", SqlDbType.VarChar, 64),
new SqlParameter("@distributor", SqlDbType.VarChar, 64),
new SqlParameter("@description", SqlDbType.VarChar, 128),
new SqlParameter("@distributionTime", SqlDbType.SmallDateTime),
new SqlParameter("@state", SqlDbType.VarChar, 16)
};
parameters[0].Value = model.feedbackID;
parameters[1].Value = model.adminName;
parameters[2].Value = model.distributor;
parameters[3].Value = model.description;
parameters[4].Value = model.distributionTime;
parameters[5].Value = model.state;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public UFB.Model.Distribution DataRowToModel(DataRow row)
{
UFB.Model.Distribution model = new UFB.Model.Distribution();
if (row != null)
{
if (row["distributionID"] != null && row["distributionID"].ToString() != "")
{
model.distributionID = int.Parse(row["distributionID"].ToString());
}
if (row["feedbackID"] != null && row["feedbackID"].ToString() != "")
{
model.feedbackID = int.Parse(row["feedbackID"].ToString());
}
if (row["adminName"] != null)
{
model.adminName = row["adminName"].ToString();
}
if (row["distributor"] != null)
{
model.distributor = row["distributor"].ToString();
}
if (row["description"] != null)
{
model.description = row["description"].ToString();
}
if (row["distributionTime"] != null && row["distributionTime"].ToString() != "")
{
model.distributionTime = DateTime.Parse(row["distributionTime"].ToString());
}
if (row["state"] != null)
{
model.state = row["state"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public UFB.Model.Distribution GetModel(int distributionID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 distributionID,feedbackID,adminName,distributor,description,distributionTime,state from Distribution ");
strSql.Append(" where distributionID=@distributionID");
SqlParameter[] parameters =
{
new SqlParameter("@distributionID", SqlDbType.Int, 4)
};
parameters[0].Value = distributionID;
UFB.Model.Distribution model = new UFB.Model.Distribution();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
