//自定义方法
private List <RegisterTB> GetAllRegisterTBBySql(string strsql)
{
//实例化范集合
List <RegisterTB> allRegisterTB = new List <RegisterTB>();
//填充数据集
DataTable dt = DBHelper.GetTable(strsql);
//遍历集合
foreach (DataRow row in dt.Rows)
{
//实例化类
RegisterTB reg = new RegisterTB();
reg.Rid = Convert.ToInt32(row["Rid"]);
reg.Cid = Convert.ToInt32(row["Cid"]);
reg.BeginNo = (long)row["BeginNo"];
reg.EndNo = (long)row["EndNo"];
reg.Buydate = Convert.ToDateTime(row["BuyDate"]);
reg.Remark = (row["Remark"] == DBNull.Value) ? "" : row["Remark"].ToString();
reg.CCompany = CCom.GetCompanyByid(Convert.ToInt32(row["Cid"]));
allRegisterTB.Add(reg);
}
return(allRegisterTB);
}
protected void TmgBtnExit_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
string cid = ddlCarrieCompany.SelectedValue.ToString();
string b = txtBeginNo.Text.Trim();
string end = txtEndNo.Text.Trim();
int cntt = regMan.number(cid, b, end);
if (cntt > 0)
{
lblok.Visible = true;
lblok.Text = "该公司的面单号已将购买!!!";
return;
}
//实例化实体类
string time = DateTime.Now.ToString();
RegisterTB reg = new RegisterTB();
reg.Cid = Convert.ToInt32(ddlCarrieCompany.SelectedValue);
reg.BeginNo = Convert.ToInt64(txtBeginNo.Text.Trim());
reg.EndNo = Convert.ToInt64(txtEndNo.Text.Trim());
reg.Buydate = Convert.ToDateTime(time);
reg.Remark = txtRemark.Text;
//添加房间信息添加成功清空控件
if (Request.QueryString["Rid"] == null)
{
if (Page.IsValid == true)
{
int cnt = regMan.InsertRegister(reg);
if (cnt > 0)
{
lblmessage.Visible = true;
lblmessage.Text = "添加成功！";
txtBeginNo.Text = "";
txtEndNo.Text = "";
txtDate.Text = "";
txtRemark.Text = "";
}
}
}
//修改功能
else
{
string Rid = Request.QueryString["Rid"].ToString();
reg.Rid = Convert.ToInt32(Rid);
int cnt = regMan.UpdateRegisterTB(reg);
txtDate.Visible = true;
string times = txtDate.Text.Trim();
reg.Buydate = Convert.ToDateTime(times);
if (cnt > 0)
{
lblmessage.Visible = true;
lblmessage.Text = "修改成功！";
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Usermanager"] == null)
{
Response.Redirect("~/Login.aspx");
}
else
{
if (!IsPostBack)
{
//填充DropDownlist控件
this.ddlCarrieCompany.DataSource = ComMan.GetAllCarrieCompany();
this.ddlCarrieCompany.DataTextField = "CoName";
this.ddlCarrieCompany.DataValueField = "Cid";
ddlCarrieCompany.DataBind();
//传过来的id不为空执行删除功能
if (Request.QueryString["Rid"] != null)
{
txtDate.Visible = true;
string Rid = Request.QueryString["Rid"].ToString();
RegisterTB Regg = new RegisterTB();
Regg = regMan.GetAllTBByRid(Rid);
ddlCarrieCompany.SelectedValue = Regg.Cid.ToString();
txtBeginNo.Text = Regg.BeginNo.ToString();
txtEndNo.Text = Regg.EndNo.ToString();
txtDate.Text = Regg.Buydate.ToString();
txtRemark.Text = Regg.Remark;
}
//清空控件
else
{
txtDate.Visible = false;
txtBeginNo.Text = "";
txtEndNo.Text = "";
txtDate.Text = "";
txtRemark.Text = "";
}
lblmessage.Visible = false;
lblok.Visible = false;
}
}
}
//插入面单购买的面单
public int InsertRegister(RegisterTB reg)
{
//拼写连接串
string strsql = "insert into RegisterTB values(@Cid,@BeginNo,@EndNo,@Buydate,@Remark)";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Cid", reg.Cid),
new SqlParameter("@BeginNo", reg.BeginNo),
new SqlParameter("@EndNo", reg.EndNo),
new SqlParameter("@Buydate", reg.Buydate),
new SqlParameter("@Remark", reg.Remark)
};
return(DBHelper.ExecuteCommand(strsql, para));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
//修改面单购买信息
public int UpdateRegisterTB(RegisterTB reg)
{
//拼写连接串
string strsql = "update RegisterTB set Cid=@Cid,BeginNo=@BeginNo,EndNo=@EndNo,Buydate=@Buydate,Remark=@Remark where Rid=@Rid";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Rid", reg.Rid),
new SqlParameter("@Cid", reg.Cid),
new SqlParameter("@BeginNo", reg.BeginNo),
new SqlParameter("@EndNo", reg.EndNo),
new SqlParameter("@Buydate", reg.Buydate),
new SqlParameter("@Remark", reg.Remark)
};
return(DBHelper.ExecuteCommand(strsql, para));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Usermanager"] == null)
{
Response.Redirect("~/Login.aspx");
}
else
{
if (!IsPostBack)
{
//填充DropDownlist控件客户
this.ddlCustomer.DataSource = CusMan.GetAllCustomers();
this.ddlCustomer.DataTextField = "CusName";
this.ddlCustomer.DataValueField = "CusID";
ddlCustomer.DataBind();
//填充DropDownlist控件承运公司
this.ddlCompany.DataSource = ComMan.GetAllCarrieCompany();
this.ddlCompany.DataTextField = "CoName";
this.ddlCompany.DataValueField = "Cid";
ddlCompany.DataBind();
//控件窗体加载不显示
lblmessage.Visible = false;
lblerror.Visible = false;
//判断页面跳转传过来是否有Nid
if (Request.QueryString["Nid"] == null)
{
if (Request.QueryString["rid"] != null)
{
txtBeginNo.Text = Request.QueryString["rid"];
txtEndNo.Text = Request.QueryString["rid"];
RegisterTB rt = new RegisterTB();
rt = regMan.GetAllRegisterTBByRid(Convert.ToInt64(Request.QueryString["rid"]));
ddlCompany.SelectedValue = rt.Cid.ToString();
CarrieCompanyTB cct = new CarrieCompanyTB();
cct = ccm.GetCompanyByid(Convert.ToInt32(ddlCompany.SelectedValue));
txtmoney.Text = cct.Cmoney.ToString();
}
else
{
txtDate.Visible = false;
//清空所有的控件
txtBeginNo.Text = "";
txtEndNo.Text = "";
txtmoney.Text = "";
txtDate.Text = "";
txtRemark.Text = "";
}
}
else
{
//接受页面穿的值
int Nid = Convert.ToInt32(Request.QueryString["Nid"].ToString());
//实例化实体类
DisNoteTB disno = new DisNoteTB();
//调用方法查询记录
disno = DIsNtMan.GetByNidDisNoteTB(Nid);
ddlCustomer.SelectedValue = disno.CusID.ToString();
ddlCompany.SelectedValue = disno.Cid.ToString();
txtBeginNo.Text = disno.BeginNo.ToString();
txtEndNo.Text = disno.EndNo.ToString();
txtDate.Text = disno.Dtime.ToString();
txtmoney.Text = disno.Sum.ToString();
if (disno.IsSet == "是")
{
rdoNo.Checked = true;
}
if (disno.IsSet == "否")
{
rdoNo.Checked = true;
}
txtRemark.Text = disno.Remark;
}
}
}
}
//修改面单购买信息
public int UpdateRegisterTB(RegisterTB reg)
{
return(registerTBService.UpdateRegisterTB(reg));
}
//插入面单购买信息
public int InsertRegister(RegisterTB reg)
{
return(registerTBService.InsertRegister(reg));
}
