/// <summary>
/// 按条件查询费用记录
/// </summary>
/// <param name="statime"></param>
/// <param name="endtime"></param>
/// <param name="cs_CarType"></param>
/// <param name="carMark"></param>
/// <returns></returns>
public IList <CostSupervise> getAllCostSupervise(string statime, string endtime, string cs_CarType, string carMark)
{
IList <CostSupervise> list = new List <CostSupervise>();
string sql = "prc_getAllCostSupervise";
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@Statime", statime),
new SqlParameter("@Endtime", endtime),
new SqlParameter("@CS_CarType", cs_CarType),
new SqlParameter("@CarMark", carMark)
};
using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, parms))
{
while (reader.Read())
{
CostSupervise cs = new CostSupervise();
cs.BillPhoto = (string)reader["BillPhoto"];
cs.CarMark = (string)reader["CarMark"];
cs.CS_CarType = (string)reader["CS_CarType"];
cs.CS_Cost = Convert.ToDouble(reader["CS_Cost"]);
cs.CS_Date = (DateTime)reader["CS_Date"];
cs.CS_Id = (int)reader["CS_Id"];
cs.CS_Item = (string)reader["CS_Item"];
cs.Remark = (string)reader["Remark"];
list.Add(cs);
}
reader.Close();
}
return(list);
}
/// <summary>
/// 根据ID查看一条详细信息
/// </summary>
/// <param name="c_Id"></param>
/// <returns></returns>
public CostSupervise getCostSuperviseById(int cs_Id)
{
IList <Cheer> list = new List <Cheer>();
string sql = "pro_getCostSuperviseById";
CostSupervise cs = null;
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@CS_Id", cs_Id)
};
using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, parms))
{
if (reader.Read())
{
cs = new CostSupervise();
cs.BillPhoto = (string)reader["BillPhoto"];
cs.CarMark = (string)reader["CarMark"];
cs.CS_CarType = (string)reader["CS_CarType"];
cs.CS_Cost = Convert.ToDouble(reader["CS_Cost"]);
cs.CS_Date = (DateTime)reader["CS_Date"];
cs.CS_Id = (int)reader["CS_Id"];
cs.CS_Item = (string)reader["CS_Item"];
cs.Remark = (string)reader["Remark"];
}
reader.Close();
}
return(cs);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string name = "0";
CS_Id = Convert.ToInt32(Request.QueryString["CS_Id"]);
name = Request.QueryString["CS_name"];
if (CS_Id != 0)
{
CostSupervise cs = CostSuperviseManager.getCostSuperviseById(CS_Id);
txtCS_Date.Value = cs.CS_Date.ToShortDateString();
ddlMark.DataSourceID = null;
ddlMark.DataSource = CarsManager.GetAllCars();
ddlMark.DataTextField = "CarMark";
ddlMark.DataValueField = "Car_Id";
ddlMark.DataBind();
ddlMark.SelectedItem.Text = cs.CarMark;
ddlCS_Item.SelectedValue = cs.CS_Item;
txtC_Sum.Text = cs.CS_Cost.ToString();
rblCarType.SelectedValue = cs.CS_CarType;
image.ImageUrl = cs.BillPhoto;
txtRemark.Value = cs.Remark;
}
if (name == "Up")
{
rblCarType.Enabled = false;
ddlMark.Enabled = false;
}
//else
//{
// rblCarType.Enabled = false;
//}
}
}
/// <summary>
/// 添加一条信息
/// </summary>
/// <param name="ch"></param>
public static int addCostSupervise(CostSupervise cs)
{
try
{
return(CostSuperviseService.addCostSupervise(cs));
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
/// <summary>
/// 查询费用表所有的车牌号
/// </summary>
/// <returns></returns>
public IList <CostSupervise> getCostSupervise()
{
IList <CostSupervise> list = new List <CostSupervise>();
string sql = "pro_getCostSupervise";
using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, null))
{
while (reader.Read())
{
CostSupervise cs = new CostSupervise();
cs.CarMark = (string)reader["CarMark"];
list.Add(cs);
}
reader.Close();
}
return(list);
}
/// <summary>
/// 更新一条信息
/// </summary>
/// <param name="cs"></param>
/// <returns></returns>
public int updateCostSupervise(CostSupervise cs)
{
string sql = "pro_updateCostSupervise";
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@CS_Id", cs.CS_Id),
new SqlParameter("@CS_Date", cs.CS_Date),
new SqlParameter("@CarMark", cs.CarMark),
new SqlParameter("@CS_Item", cs.CS_Item),
new SqlParameter("@CS_Cost", cs.CS_Cost),
new SqlParameter("@CS_CarType", cs.CS_CarType),
new SqlParameter("@Remark", cs.Remark),
new SqlParameter("@BillPhoto", cs.BillPhoto)
};
int result = DBHelper.ExecuteNonQueryProc(sql, parms);
return(result);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string name = "0";
name = Request.QueryString["CS_name"];
CostSupervise cs = new CostSupervise();
cs.CS_Id = CS_Id;
cs.CS_Date = Convert.ToDateTime(txtCS_Date.Value);
cs.CarMark = ddlMark.SelectedItem.Text;
cs.CS_Item = ddlCS_Item.SelectedValue;
cs.CS_Cost = Convert.ToDouble(txtC_Sum.Text);
cs.CS_CarType = rblCarType.SelectedValue;
if (ddlMark.SelectedItem.Text == "请选择")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请选择正确的车牌号！');", true);
return;
}
//图片上传判断
string FileName = "";
if (fuBillPhoto.PostedFile != null)
{
FileName = System.IO.Path.GetFileName(fuBillPhoto.PostedFile.FileName).ToLower();
if (FileName == "")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('清单照片不能为空！');", true);
return;
}
fuBillPhoto.PostedFile.SaveAs(Server.MapPath("~/images/UpLoad/" + FileName));
cs.BillPhoto = "~/images/UpLoad/" + FileName;
}
else
{
cs.BillPhoto = image.ImageUrl;
}
image.ImageUrl = cs.BillPhoto;
cs.Remark = Server.HtmlDecode(txtRemark.Value);
if (name == "Up")
{
int result = CostSuperviseManager.updateCostSupervise(cs);
if (result != 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新成功！');window.location.href='ElseCostlist.aspx'", true);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新失败！');", true);
txtCS_Date.Value = "";
txtC_Sum.Text = "";
txtRemark.Value = "";
return;
}
}
else
{
int result = CostSuperviseManager.addCostSupervise(cs);
if (result != 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功！');window.location.href='ElseCostlist.aspx'", true);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败！');", true);
txtCS_Date.Value = "";
txtC_Sum.Text = "";
txtRemark.Value = "";
return;
}
}
}
