110,536
社区成员
发帖
与我相关
我的任务
分享
protected void BtnAdd_Click(object sender, EventArgs e)
{
Td_Visa visa = new Td_Visa();
visa.VisaName = TxtTitle.Text;
visa.VisaPrice = TxtPrice.Text;
visa.VisaCb = TxtCb.Text;
visa.VisaTh = TxtTh.Text;
visa.VisaStop = TxtStop.Text;
visa.VisaFanwei = Txtfw.Text;
visa.VisaRegionId = Convert.ToInt32(ViewState["regionid"].ToString());
visa.VisaIntro = TxtContent.Text;
visa.VisaMark = TxtMark.Text;
if (CheckBox1.Checked == true)
{
visa.VisaType = "2";
}
if (CheckBox1.Checked == false)
{
visa.VisaType = "1";
}
visa.VisaSqys = Txtsqys.Text;
visa.VisaTime = TxtTime.Text;
if (yqh1.Checked == true)
{
visa.Visayqh = yqh1.Text;
}
if (yqh2.Checked == true)
{
visa.Visayqh = yqh2.Text;
}
if (yy1.Checked == true)
{
visa.Visayy = yy1.Text;
}
if (yy2.Checked == true)
{
visa.Visayy = yy2.Text;
}
if (ms1.Checked == true)
{
visa.Visams = ms1.Text;
}
if (ms2.Checked == true)
{
visa.Visams = ms2.Text;
}
if (fy1.Checked == true)
{
visa.Visaqzf = fy1.Text;
}
if (fy2.Checked == true)
{
visa.Visaqzf = fy2.Text;
}
Td_VisaManager.AddTd_Visa(visa);
Response.Write("<script>window.location.href='visaList.aspx?lei=" + visa.VisaRegionId + "';alert('添加成功!')</script>");
}
public class Td_Visa
{
private int visaId;
private Td_Region fk_visaRegion = new Td_Region();
private string visaName = String.Empty;
private string visaPrice = String.Empty;
private string visaCb = String.Empty;
private string visaTh = String.Empty;
private string visaStop = String.Empty;
private string visaTime = String.Empty;
private string visaFanwei = String.Empty;
private string visaIntro = String.Empty;
private int visaRegionId;
private string visaMuban = String.Empty;
private string visaMark = String.Empty;
private string visaType = String.Empty;
private string visaSqys = String.Empty;
private string visayqh = String.Empty;
private string visams = String.Empty;
private string visayy = String.Empty;
private string visaqzf = String.Empty;
private string visaImage = String.Empty;
public int VisaId
{
get { return this.visaId; }
set { this.visaId = value; }
}
public Td_Region FK_VisaRegion
{
get { return this.fk_visaRegion; }
set { this.fk_visaRegion = value; }
}
public string VisaName
{
get { return this.visaName; }
set { this.visaName = value; }
}
public string VisaPrice
{
get { return this.visaPrice; }
set { this.visaPrice = value; }
}
public string VisaCb
{
get { return this.visaCb; }
set { this.visaCb = value; }
}
public string VisaTh
{
get { return this.visaTh; }
set { this.visaTh = value; }
}
public static partial class Td_VisaManager
{
public static int AddTd_Visa(Td_Visa td_Visa)
{
return Td_VisaService.InsertTd_Visa(td_Visa);
}
public static void DeleteTd_Visa(Td_Visa td_Visa)
{
Td_VisaService.DeleteTd_Visa(td_Visa);
}
public static void DeleteTd_VisaByVisaId(int visaId)
{
Td_VisaService.DeleteTd_VisaByVisaId(visaId);
}
public static void ModifyTd_Visa(Td_Visa td_Visa)
{
Td_VisaService.UpdateTd_Visa(td_Visa);
}
public static int InsertTd_Visa(Td_Visa td_Visa)
{
//定义sql语句
string sql =
"INSERT Td_Visa (VisaName, VisaPrice, VisaCb,VisaTh,VisaStop, VisaTime, VisaFanwei, VisaIntro, VisaRegionId, VisaMuban, VisaMark, VisaType, VisaSqys, Visayqh, Visams, Visayy, Visaqzf, VisaImage)" +
"VALUES (@VisaName, @VisaPrice,@VisaCb, @VisaTh,@VisaStop, @VisaTime, @VisaFanwei, @VisaIntro, @VisaRegionId, @VisaMuban, @VisaMark, @VisaType, @VisaSqys, @Visayqh, @Visams, @Visayy, @Visaqzf, @VisaImage);select @@identity";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VisaName", td_Visa.VisaName),
new SqlParameter("@VisaPrice", td_Visa.VisaPrice),
new SqlParameter("@VisaCb ", td_Visa.VisaCb),
new SqlParameter("@VisaTh", td_Visa.VisaTh),
new SqlParameter("@VisaStop", td_Visa.VisaStop),
new SqlParameter("@VisaTime", td_Visa.VisaTime),
new SqlParameter("@VisaFanwei", td_Visa.VisaFanwei),
new SqlParameter("@VisaIntro", td_Visa.VisaIntro),
new SqlParameter("@VisaRegionId", td_Visa.VisaRegionId),
new SqlParameter("@VisaMuban", td_Visa.VisaMuban),
new SqlParameter("@VisaMark", td_Visa.VisaMark),
new SqlParameter("@VisaType", td_Visa.VisaType),
new SqlParameter("@VisaSqys", td_Visa.VisaSqys),
new SqlParameter("@Visayqh", td_Visa.Visayqh),
new SqlParameter("@Visams", td_Visa.Visams),
new SqlParameter("@Visayy", td_Visa.Visayy),
new SqlParameter("@Visaqzf", td_Visa.Visaqzf),
new SqlParameter("@VisaImage", td_Visa.VisaImage)
};
//执行sql语句
return DBHelper.GetScalar(sql, para);
}
public static void DeleteTd_Visa(Td_Visa td_Visa)
{
DeleteTd_VisaByVisaId(td_Visa.VisaId);
}
public static void DeleteTd_VisaByVisaId(int visaId)
{
//定义sql语句
string sql = "DELETE Td_Visa WHERE VisaId = @VisaId";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VisaId", visaId)
};
//执行sql语句
DBHelper.ExecuteCommand(sql, para);
}
public static void UpdateTd_Visa(Td_Visa td_Visa)
{
//定义sql语句
string sql =
"UPDATE Td_Visa " +
"SET " +
"VisaName = @VisaName ," +
"VisaPrice = @VisaPrice ," +
"VisaCb = @VisaCb ," +
"VisaTh = @VisaTh ," +
"VisaStop = @VisaStop ," +
"VisaTime = @VisaTime ," +
"VisaFanwei = @VisaFanwei ," +
"VisaIntro = @VisaIntro ," +
"VisaRegionId = @VisaRegionId ," +
"VisaMuban = @VisaMuban ," +
"VisaMark = @VisaMark ," +
"VisaType = @VisaType ," +
"VisaSqys = @VisaSqys ," +
"Visayqh = @Visayqh ," +
"Visams = @Visams ," +
"Visayy = @Visayy ," +
"Visaqzf = @Visaqzf ," +
"VisaImage = @VisaImage " +
"WHERE VisaId = @VisaId";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VisaId", td_Visa.VisaId),
new SqlParameter("@VisaName", td_Visa.VisaName),
new SqlParameter("@VisaPrice", td_Visa.VisaPrice),
new SqlParameter("@VisaCb", td_Visa.VisaCb),
new SqlParameter("@VisaTh", td_Visa.VisaTh),
new SqlParameter("@VisaStop", td_Visa.VisaStop),
new SqlParameter("@VisaTime", td_Visa.VisaTime),
new SqlParameter("@VisaFanwei", td_Visa.VisaFanwei),
new SqlParameter("@VisaIntro", td_Visa.VisaIntro),
new SqlParameter("@VisaRegionId", td_Visa.VisaRegionId),
new SqlParameter("@VisaMuban", td_Visa.VisaMuban),
new SqlParameter("@VisaMark", td_Visa.VisaMark),
new SqlParameter("@VisaType", td_Visa.VisaType),
new SqlParameter("@VisaSqys", td_Visa.VisaSqys),
new SqlParameter("@Visayqh", td_Visa.Visayqh),
new SqlParameter("@Visams", td_Visa.Visams),
new SqlParameter("@Visayy", td_Visa.Visayy),
new SqlParameter("@Visaqzf", td_Visa.Visaqzf),
new SqlParameter("@VisaImage", td_Visa.VisaImage)
};
//执行sql语句
DBHelper.ExecuteCommand(sql, para);
}
<table border="0" cellspacing="0" cellpadding="0"
style="font-size:12px; line-height:40px; width: 819px;">
<tr>
<td align="right">签证类型名称:</td>
<td colspan="3">
<asp:TextBox ID="TxtTitle" runat="server" Width="463px"></asp:TextBox><asp:Label
ID="Label1" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td align="right">签证价格:</td>
<td class="style1" >
<asp:TextBox ID="TxtPrice" runat="server" Width="212px"></asp:TextBox>
</td>
<td align="right">是否加急:</td>
<td>
<asp:CheckBox ID="CheckBox1" runat="server" Text="加急" />
</td>
</tr>
<tr>
<td align="right">签证成本:</td>
<td class="style1" >
<asp:TextBox ID="TxtCb" runat="server" Width="212px"></asp:TextBox>
</td>
<td align="right">同行报价:</td>
<td>
<asp:TextBox ID="TxtTh" runat="server" Width="212px"></asp:TextBox>
</td>
</tr>
<tr>
<td align="right">停留时间:</td>
<td class="style1" >
<asp:TextBox ID="TxtStop" runat="server" Width="212px"></asp:TextBox>
</td></tr></table>
protected void BtnAdd_Click(object sender, EventArgs e)
{
Td_Visa visa = new Td_Visa();
visa.VisaName = TxtTitle.Text;
visa.VisaPrice = TxtPrice.Text;
visa.VisaCb = TxtCb.Text;
visa.VisaTh = TxtTh.Text;
visa.VisaStop = TxtStop.Text;
}