/// <summary>
///[tb_line]表查询实体的方法
/// </summary>
public static Tb_line getTb_lineById(int id)
{
Tb_line tb_line = null;
string sql = "select * from tb_line where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
tb_line = new Tb_line();
foreach (DataRow dr in dt.Rows)
{
tb_line.Id = Convert.ToInt32(dr["id"]);
tb_line.Line = Convert.ToString(dr["line"]);
tb_line.LineRemark = Convert.ToString(dr["lineRemark"]);
tb_line.AutoCode = Convert.ToString(dr["autocode"]);
}
}
return(tb_line);
}
/// <summary>
/// Edit
/// </summary>
private void loadData()
{
Tb_line line = Tb_lineManager.getTb_lineById(Convert.ToInt32(Request.QueryString["id"]));
this.txtlinename.Text = line.Line;
this.txtlineremark.Text = line.LineRemark;
this.txtautocode.Text = line.AutoCode;
}
/// <summary>
///[tb_line]表添加的方法
/// </summary>
public static int addTb_line(Tb_line tb_line)
{
string sql = "insert into tb_line([line],[lineRemark],[autocode]) values (@line,@lineRemark,@autocode)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@line", tb_line.Line),
new SqlParameter("@lineRemark", tb_line.LineRemark),
new SqlParameter("@autocode", tb_line.AutoCode)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[tb_line]表修改的方法
/// </summary>
public static int updateTb_lineById(Tb_line tb_line)
{
string sql = "update tb_line set line=@line,lineRemark=@lineRemark,autocode=@autocode where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", tb_line.Id),
new SqlParameter("@line", tb_line.Line),
new SqlParameter("@lineRemark", tb_line.LineRemark),
new SqlParameter("@autocode", tb_line.AutoCode)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibtnAdd_Click(object sender, ImageClickEventArgs e)
{
Tb_line line = Tb_lineManager.getTb_lineById(Convert.ToInt32(Request.QueryString["id"]));
line.Line = this.txtlinename.Text;
line.LineRemark = this.txtlineremark.Text;
line.AutoCode = this.txtautocode.Text;
int count = Tb_lineManager.updateTb_line(line);
if (count > 0)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "edit", "<script>alert('保存成功');window.location='LineList.aspx'</script>", false);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibtnAdd_Click(object sender, ImageClickEventArgs e)
{
Tb_line lineModel = new Tb_line();
lineModel.Line = this.txtlinename.Text;
lineModel.LineRemark = this.txtlineremark.Text;
lineModel.AutoCode = this.txtautocode.Text;
int count = Tb_lineManager.addTb_line(lineModel);
if (count > 0)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('添加成功');window.location='LineList.aspx'</script>", false);
}
}
/// <summary>
/// 得到线路名称
/// </summary>
/// <param name="line"></param>
/// <returns></returns>
private string GetLineName(string line)
{
int lineId = 0;
int.TryParse(line, out lineId);
Tb_line lineModel = Tb_lineManager.getTb_lineById(lineId);
if (lineModel != null)
{
return(lineModel.Line);
}
else
{
return("线路未知");
}
}
/// <summary>
/// 返回名称,不包含流水号
/// 根据出团日期来编码订单序号
/// </summary>
private string Numbers(string txtformat)
{
string result = ""; //返回的名称
DateTime outtime = new DateTime();
DateTime.TryParse(this.txtOutDate.Value, out outtime);
int lineid = 0;
int.TryParse(this.ddlLine.SelectedValue, out lineid);
Tb_line line = Tb_lineManager.getTb_lineById(lineid);
string linecode = ""; //线路自动编码标识符
if (line != null)
{
linecode = line.AutoCode;
}
LoginInfo login = Session["login"] as LoginInfo;
string departcode = DepartmentInfoManager.getDepartmentInfoById(login.Departid).AutoCode; //部门自动编码标识符
if (txtformat.Contains("[YYYY]"))
{
txtformat = txtformat.Replace("[YYYY]", outtime.ToString("yyyy"));
}
if (txtformat.Contains("[YY]"))
{
txtformat = txtformat.Replace("[YY]", outtime.ToString("yy"));
}
if (txtformat.Contains("[MM]"))
{
txtformat = txtformat.Replace("[MM]", outtime.ToString("MM"));
}
if (txtformat.Contains("[DD]"))
{
txtformat = txtformat.Replace("[DD]", outtime.ToString("dd"));
}
if (txtformat.Contains("[XL]"))
{
txtformat = txtformat.Replace("[XL]", linecode);
}
if (txtformat.Contains("[BM]"))
{
txtformat = txtformat.Replace("[BM]", departcode);
}
result = txtformat;
return(result);
}
/// <summary>
///根据SQL语句获取实体
/// </summary>
public static Tb_line getTb_lineBySql(string sql)
{
Tb_line tb_line = null;
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
tb_line = new Tb_line();
foreach (DataRow dr in dt.Rows)
{
tb_line.Id = Convert.ToInt32(dr["id"]);
tb_line.Line = Convert.ToString(dr["line"]);
tb_line.LineRemark = Convert.ToString(dr["lineRemark"]);
tb_line.AutoCode = Convert.ToString(dr["autocode"]);
}
}
return(tb_line);
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
public static IList <Tb_line> getTb_linesBySql(string sql)
{
IList <Tb_line> list = new List <Tb_line>();
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Tb_line tb_line = new Tb_line();
tb_line.Id = Convert.ToInt32(dr["id"]);
tb_line.Line = Convert.ToString(dr["line"]);
tb_line.LineRemark = Convert.ToString(dr["lineRemark"]);
tb_line.AutoCode = Convert.ToString(dr["autocode"]);
list.Add(tb_line);
}
}
return(list);
}
public static int addTb_line(Tb_line tb_line)
{
return(Tb_lineService.addTb_line(tb_line));
}
public static int updateTb_line(Tb_line tb_line)
{
return(Tb_lineService.updateTb_lineById(tb_line));
}
