/// <summary>
/// 得到一个对象实体
/// </summary>
public la.Model.travel GetModel(int travle_ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 travle_ID,promoter_userid,release_time,Destination,startplace,return_time,start_time,transportation,fee,travle_theme,travle_personcount,companion_condition,travle_msg,pic1,pic2,pic3,income_condition,car_condition,height_condition,credit_condition,wantget_gift,wantsend_gift,reg_fee from travel ");
strSql.Append(" where travle_ID=@travle_ID ");
SqlParameter[] parameters = {
new SqlParameter("@travle_ID", SqlDbType.Int,4) };
parameters[0].Value = travle_ID;
la.Model.travel model=new la.Model.travel();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public la.Model.travel DataRowToModel(DataRow row)
{
la.Model.travel model=new la.Model.travel();
if (row != null)
{
if(row["travle_ID"]!=null && row["travle_ID"].ToString()!="")
{
model.travle_ID=int.Parse(row["travle_ID"].ToString());
}
if(row["promoter_userid"]!=null && row["promoter_userid"].ToString()!="")
{
model.promoter_userid=row["promoter_userid"].ToString();
}
if(row["release_time"]!=null && row["release_time"].ToString()!="")
{
model.release_time=DateTime.Parse(row["release_time"].ToString());
}
if(row["Destination"]!=null)
{
model.Destination=row["Destination"].ToString();
}
if(row["startplace"]!=null)
{
model.startplace=row["startplace"].ToString();
}
if(row["return_time"]!=null && row["return_time"].ToString()!="")
{
model.return_time=DateTime.Parse(row["return_time"].ToString());
}
if(row["start_time"]!=null && row["start_time"].ToString()!="")
{
model.start_time=DateTime.Parse(row["start_time"].ToString());
}
if(row["transportation"]!=null)
{
model.transportation=row["transportation"].ToString();
}
if(row["fee"]!=null)
{
model.fee=row["fee"].ToString();
}
if(row["travle_theme"]!=null)
{
model.travle_theme=row["travle_theme"].ToString();
}
if(row["travle_personcount"]!=null && row["travle_personcount"].ToString()!="")
{
model.travle_personcount=int.Parse(row["travle_personcount"].ToString());
}
if(row["companion_condition"]!=null)
{
model.companion_condition=row["companion_condition"].ToString();
}
if(row["travle_msg"]!=null)
{
model.travle_msg=row["travle_msg"].ToString();
}
if(row["pic1"]!=null)
{
model.pic1=row["pic1"].ToString();
}
if(row["pic2"]!=null)
{
model.pic2=row["pic2"].ToString();
}
if(row["pic3"]!=null)
{
model.pic3=row["pic3"].ToString();
}
if(row["income_condition"]!=null)
{
model.income_condition=row["income_condition"].ToString();
}
if(row["car_condition"]!=null)
{
model.car_condition=row["car_condition"].ToString();
}
if(row["height_condition"]!=null)
{
model.height_condition=row["height_condition"].ToString();
}
if(row["credit_condition"]!=null)
{
model.credit_condition=row["credit_condition"].ToString();
}
if(row["wantget_gift"]!=null)
{
model.wantget_gift=row["wantget_gift"].ToString();
}
if(row["wantsend_gift"]!=null)
{
model.wantsend_gift=row["wantsend_gift"].ToString();
}
if(row["reg_fee"]!=null && row["reg_fee"].ToString()!="")
{
model.reg_fee=decimal.Parse(row["reg_fee"].ToString());
}
}
return model;
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr="";
if(!PageValidate.IsNumber(txttravle_ID.Text))
{
strErr+="旅行ID格式错误！\\n";
}
if(!PageValidate.IsNumber(txtpromoter_userid.Text))
{
strErr+="发起人格式错误！\\n";
}
if(!PageValidate.IsDateTime(txtrelease_time.Text))
{
strErr+="发布时间格式错误！\\n";
}
if(this.txtDestination.Text.Trim().Length==0)
{
strErr+="目的地不能为空！\\n";
}
if(this.txtstartplace.Text.Trim().Length==0)
{
strErr+="出发地不能为空！\\n";
}
if(!PageValidate.IsDateTime(txtreturn_time.Text))
{
strErr+="返回时间格式错误！\\n";
}
if(!PageValidate.IsDateTime(txtstart_time.Text))
{
strErr+="出发时间格式错误！\\n";
}
if(this.txttransportation.Text.Trim().Length==0)
{
strErr+="交通方式不能为空！\\n";
}
if(this.txtfee.Text.Trim().Length==0)
{
strErr+="费用说明不能为空！\\n";
}
if(this.txttravle_theme.Text.Trim().Length==0)
{
strErr+="旅行主题不能为空！\\n";
}
if(!PageValidate.IsNumber(txttravle_personcount.Text))
{
strErr+="需要旅伴人数格式错误！\\n";
}
if(this.txtcompanion_condition.Text.Trim().Length==0)
{
strErr+="旅伴要求不能为空！\\n";
}
if(this.txttravle_msg.Text.Trim().Length==0)
{
strErr+="留言不能为空！\\n";
}
if(this.txtpic1.Text.Trim().Length==0)
{
strErr+="图1不能为空！\\n";
}
if(this.txtpic2.Text.Trim().Length==0)
{
strErr+="图2不能为空！\\n";
}
if(this.txtpic3.Text.Trim().Length==0)
{
strErr+="图3不能为空！\\n";
}
if(this.txtincome_condition.Text.Trim().Length==0)
{
strErr+="旅伴收入要求不能为空！\\n";
}
if(this.txtcar_condition.Text.Trim().Length==0)
{
strErr+="旅伴车辆要求不能为空！\\n";
}
if(this.txtheight_condition.Text.Trim().Length==0)
{
strErr+="旅伴身高要求不能为空！\\n";
}
if(this.txtcredit_condition.Text.Trim().Length==0)
{
strErr+="旅伴信用要求不能为空！\\n";
}
if(this.txtwantget_gift.Text.Trim().Length==0)
{
strErr+="想得到的礼品不能为空！\\n";
}
if(this.txtwantsend_gift.Text.Trim().Length==0)
{
strErr+="想送出的礼品不能为空！\\n";
}
if(!PageValidate.IsDecimal(txtreg_fee.Text))
{
strErr+="报名费用（旅币)格式错误！\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
int travle_ID=int.Parse(this.txttravle_ID.Text);
int promoter_userid=int.Parse(this.txtpromoter_userid.Text);
DateTime release_time=DateTime.Parse(this.txtrelease_time.Text);
string Destination=this.txtDestination.Text;
string startplace=this.txtstartplace.Text;
DateTime return_time=DateTime.Parse(this.txtreturn_time.Text);
DateTime start_time=DateTime.Parse(this.txtstart_time.Text);
string transportation=this.txttransportation.Text;
string fee=this.txtfee.Text;
string travle_theme=this.txttravle_theme.Text;
int travle_personcount=int.Parse(this.txttravle_personcount.Text);
string companion_condition=this.txtcompanion_condition.Text;
string travle_msg=this.txttravle_msg.Text;
string pic1=this.txtpic1.Text;
string pic2=this.txtpic2.Text;
string pic3=this.txtpic3.Text;
string income_condition=this.txtincome_condition.Text;
string car_condition=this.txtcar_condition.Text;
string height_condition=this.txtheight_condition.Text;
string credit_condition=this.txtcredit_condition.Text;
string wantget_gift=this.txtwantget_gift.Text;
string wantsend_gift=this.txtwantsend_gift.Text;
decimal reg_fee=decimal.Parse(this.txtreg_fee.Text);
la.Model.travel model=new la.Model.travel();
model.travle_ID=travle_ID;
model.promoter_userid=promoter_userid;
model.release_time=release_time;
model.Destination=Destination;
model.startplace=startplace;
model.return_time=return_time;
model.start_time=start_time;
model.transportation=transportation;
model.fee=fee;
model.travle_theme=travle_theme;
model.travle_personcount=travle_personcount;
model.companion_condition=companion_condition;
model.travle_msg=travle_msg;
model.pic1=pic1;
model.pic2=pic2;
model.pic3=pic3;
model.income_condition=income_condition;
model.car_condition=car_condition;
model.height_condition=height_condition;
model.credit_condition=credit_condition;
model.wantget_gift=wantget_gift;
model.wantsend_gift=wantsend_gift;
model.reg_fee=reg_fee;
la.BLL.travel bll=new la.BLL.travel();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功！","add.aspx");
}
