/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "peixunban1";
* parameters[1].Value = "id";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 更新一条备注
/// </summary>
public bool Update_beizhu(Maticsoft.Model.peixunban1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update peixunban1 set ");
strSql.Append("beizhu=@beizhu ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@beizhu", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.beizhu;
parameters[1].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int id)
{
Maticsoft.BLL.peixunban1 bll = new Maticsoft.BLL.peixunban1();
Maticsoft.Model.peixunban1 model = bll.GetModel(id);
id_load = model.id.ToString();
this.txtstart_time.Text = model.start_time.ToString();
this.txtend_time.Text = model.end_time.ToString();
this.txtname.Text = model.name;
this.txtcontact.Text = model.contact;
this.txtbeizhu.Text = model.beizhu;
this.txtphone.Text = model.phone;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.peixunban1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update peixunban1 set ");
strSql.Append("start_time=@start_time,");
strSql.Append("end_time=@end_time,");
strSql.Append("name=@name,");
strSql.Append("contact=@contact,");
strSql.Append("sinal=@sinal,");
strSql.Append("beizhu=@beizhu,");
strSql.Append("phone=@phone");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@start_time", SqlDbType.Date, 3),
new SqlParameter("@end_time", SqlDbType.Date, 3),
new SqlParameter("@name", SqlDbType.NChar, 50),
new SqlParameter("@contact", SqlDbType.NChar, 10),
new SqlParameter("@sinal", SqlDbType.Int, 4),
new SqlParameter("@beizhu", SqlDbType.NVarChar, 50),
new SqlParameter("@phone", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.start_time;
parameters[1].Value = model.end_time;
parameters[2].Value = model.name;
parameters[3].Value = model.contact;
parameters[4].Value = model.sinal;
parameters[5].Value = model.beizhu;
parameters[6].Value = model.phone;
parameters[7].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.peixunban1 DataRowToModel(DataRow row)
{
Maticsoft.Model.peixunban1 model = new Maticsoft.Model.peixunban1();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["start_time"] != null && row["start_time"].ToString() != "")
{
model.start_time = DateTime.Parse(row["start_time"].ToString());
}
if (row["end_time"] != null && row["end_time"].ToString() != "")
{
model.end_time = DateTime.Parse(row["end_time"].ToString());
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["contact"] != null)
{
model.contact = row["contact"].ToString();
}
if (row["sinal"] != null && row["sinal"].ToString() != "")
{
model.sinal = int.Parse(row["sinal"].ToString());
}
if (row["beizhu"] != null)
{
model.beizhu = row["beizhu"].ToString();
}
if (row["phone"] != null)
{
model.phone = row["phone"].ToString();
}
}
return(model);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsDateTime(txtstart_time.Text))
{
strErr += "start_time格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtend_time.Text))
{
strErr += "end_time格式错误！\\n";
}
if (this.txtname.Text.Trim().Length == 0)
{
strErr += "name不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
DateTime start_time = DateTime.Parse(this.txtstart_time.Text);
DateTime end_time = DateTime.Parse(this.txtend_time.Text);
string name = this.txtname.Text;
Maticsoft.Model.peixunban1 model = new Maticsoft.Model.peixunban1();
model.start_time = start_time;
model.end_time = end_time;
model.name = name;
model.beizhu = beizhu.Text;
model.contact = contact.Text;
model.phone = phone.Text;
model.sinal = Convert.ToInt16(sinal.SelectedValue);
Maticsoft.BLL.peixunban1 bll = new Maticsoft.BLL.peixunban1();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.peixunban1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into peixunban1(");
strSql.Append("start_time,end_time,name,contact,sinal,beizhu,phone)");
strSql.Append(" values (");
strSql.Append("@start_time,@end_time,@name,@contact,@sinal,@beizhu,@phone)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@start_time", SqlDbType.Date, 3),
new SqlParameter("@end_time", SqlDbType.Date, 3),
new SqlParameter("@name", SqlDbType.NChar, 50),
new SqlParameter("@contact", SqlDbType.NChar, 10),
new SqlParameter("@sinal", SqlDbType.Int, 4),
new SqlParameter("@beizhu", SqlDbType.NVarChar, 50),
new SqlParameter("@phone", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.start_time;
parameters[1].Value = model.end_time;
parameters[2].Value = model.name;
parameters[3].Value = model.contact;
parameters[4].Value = model.sinal;
parameters[5].Value = model.beizhu;
parameters[6].Value = model.phone;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public void loaddata()
{
if (Session["peixunban"] == null)
{
Response.Redirect("branch_add.aspx");
}
else
{
if (Convert.ToInt16(Session["screen"]) == 1)
{
Literal_css.Text = "<link href='css/form_css.css' rel='stylesheet' type='text/css' />";
}
else
{
Literal_css.Text = "<link href='css/form_moblie.css' rel='stylesheet' type='text/css' />";
}
pxb = (Maticsoft.Model.peixunban1)Session["peixunban"];
num = Convert.ToInt16(pxb.beizhu);
peixunbanid = pxb.id;
Literal1.Text = pxb.name;
cleaning_fee.Text = clean_fee(Convert.ToInt16(pxb.beizhu)).ToString();
fantang.Text = dingcan(Convert.ToDateTime(pxb.start_time), Convert.ToDateTime(pxb.end_time), Convert.ToInt16(pxb.beizhu));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.peixunban1 GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,start_time,end_time,name,contact,sinal,beizhu,phone from peixunban1 ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Maticsoft.Model.peixunban1 model = new Maticsoft.Model.peixunban1();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void ShowInfo(int id)
{
Maticsoft.BLL.peixunban1 bll = new Maticsoft.BLL.peixunban1();
Maticsoft.Model.peixunban1 model = bll.GetModel(id);
this.lblstart_time.Text = Convert.ToDateTime(model.start_time.ToString()).ToShortDateString();
this.lblend_time.Text = Convert.ToDateTime(model.end_time.ToString()).ToShortDateString();
this.lblname.Text = model.name;
contact.Text = model.contact;
phone.Text = model.phone;
beizhu.Text = model.beizhu;
Maticsoft.BLL.branch_company bhc_bll = new BLL.branch_company();
Maticsoft.Model.branch_company bhc_mod = bhc_bll.GetModel_bypeixunban(id);
start_detail.Text = bhc_mod.start_detail.ToString();
end_detail.Text = bhc_mod.end_detail.ToString();
num.Text = bhc_mod.num.ToString() + "人";
num_detail.Text = bhc_mod.num_detail.ToString();
cleaning_fee.Text = bhc_mod.cleaning_fee.ToString() + "元";
fapiao_taitou.Text = bhc_mod.fapiao_taitou.ToString();
basketball_time.Text = bhc_mod.basketball_time.ToString();
fantang.Text = bhc_mod.fantang.ToString();
fangka_print.Text = (bhc_mod.fangka_print == 1 ? "不打印名字" : "打印名字");
xishu_yongpin.Text = (bhc_mod.xishu_yongpin == 1 ? "简易洗漱用品" : "旅行套装");
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsDateTime(txtstart_time.Text))
{
strErr += "开始时间格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtend_time.Text))
{
strErr += "结束时间格式错误！\\n";
}
if (this.txtname.Text.Trim().Length == 0)
{
strErr += "培训班名称不能为空！\\n";
}
if (this.txtcontact.Text.Trim().Length == 0)
{
strErr += "联系人不能为空！\\n";
}
if (this.txtphone.Text.Trim().Length == 0)
{
strErr += "联系电话不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int id = int.Parse(id_load);
DateTime start_time = DateTime.Parse(this.txtstart_time.Text);
DateTime end_time = DateTime.Parse(this.txtend_time.Text);
string name = this.txtname.Text;
string contact = this.txtcontact.Text;
int sinal = 2;
string beizhu = this.txtbeizhu.Text;
string phone = this.txtphone.Text;
Maticsoft.Model.peixunban1 model = new Maticsoft.Model.peixunban1();
model.id = id;
model.start_time = start_time;
model.end_time = end_time;
model.name = name;
model.contact = contact;
model.sinal = sinal;
model.beizhu = beizhu;
model.phone = phone;
Maticsoft.BLL.peixunban1 bll = new Maticsoft.BLL.peixunban1();
bll.Update(model);
#region 开始branch_company表的数据更新
Maticsoft.BLL.branch_company bnc_bll = new BLL.branch_company();
Maticsoft.Model.branch_company bnc_mod = bnc_bll.GetModel_bypeixunban(id);
if (this.txtstart_detail.Text.Trim().Length == 0)
{
strErr += "入住具体时间不能为空！\\n";
}
if (this.txtend_detail.Text.Trim().Length == 0)
{
strErr += "退房具体时间不能为空！\\n";
}
if (!PageValidate.IsNumber(txtnum.Text))
{
strErr += "人数格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtcleaning_fee.Text))
{
strErr += "清洁费用格式错误！\\n";
}
if (this.txtfapiao_taitou.Text.Trim().Length == 0)
{
strErr += "发票抬头不能为空！\\n";
}
if (this.txtfantang.Text.Trim().Length == 0)
{
strErr += "饭堂订餐不能为空！\\n";
}
//if (!PageValidate.IsNumber(txtfangka_print.Text))
//{
// strErr += "fangka_print格式错误！\\n";
//}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string start_detail = this.txtstart_detail.Text;
string end_detail = this.txtend_detail.Text;
int num = int.Parse(this.txtnum.Text);
string num_detail = this.txtnum_detail.Text;
decimal cleaning_fee = decimal.Parse(this.txtcleaning_fee.Text);
string fapiao_taitou = this.txtfapiao_taitou.Text;
string basketball_time = this.txtbasketball_time.Text;
string fantang = this.txtfantang.Text;
//int fangka_print1 = int.Parse(this.txtfangka_print.Text);
Maticsoft.Model.branch_company model_branch = new Maticsoft.Model.branch_company();
model_branch.id = bnc_mod.id;
model_branch.peixunban_id = id;
model_branch.start_detail = start_detail;
model_branch.end_detail = end_detail;
model_branch.num = num;
model_branch.num_detail = num_detail;
model_branch.cleaning_fee = cleaning_fee;
model_branch.fapiao_taitou = fapiao_taitou;
model_branch.basketball_time = basketball_time;
model_branch.fantang = fantang;
model_branch.fangka_print = Convert.ToInt16(fangka_print.SelectedValue);
model_branch.fengongsi = bnc_mod.fengongsi;
model_branch.date = DateTime.Today;
model_branch.xishu_yongpin = Convert.ToInt16(xishu.SelectedValue);
Maticsoft.BLL.branch_company bll_branch = new Maticsoft.BLL.branch_company();
bll_branch.Update(model_branch);
#endregion
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
