protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txt_name = GridView1.Rows[e.RowIndex].FindControl("txt_name") as TextBox;
TextBox txt_remark = GridView1.Rows[e.RowIndex].FindControl("txt_remark") as TextBox;
TextBox txt_sort = GridView1.Rows[e.RowIndex].FindControl("txt_sort") as TextBox;
int temp_sort = 0;
if (!int.TryParse(txt_sort.Text.Trim(), out temp_sort))
{
AJAXManager.Alert(this.UpdatePanel1, "请输入正确的排序");
return;
}
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["cid"]);
courier dp = BLL.courierManager.SearchByID(id);
dp.cname = string.IsNullOrEmpty(txt_name.Text) ? "" : txt_name.Text.Trim();
dp.cremark = string.IsNullOrEmpty(txt_remark.Text) ? "" : txt_remark.Text.Trim();
dp.csort = temp_sort;
if (BLL.courierManager.Update(dp) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
GridView1.EditIndex = -1;
bind();
}
}
/// <summary>
/// 从一个OleDbDataReader里读数据
/// </summary>
/// <param name="Reader">OleDbDataReader</param>
/// <returns>courierExample</returns>
public static courier GetByReader(OleDbDataReader Reader)
{
courier courierExample = new courier();
courierExample.cid = Reader["cid"] == DBNull.Value ? 0 : (int)Reader["cid"];
courierExample.cname = Reader["cname"] == DBNull.Value ? null : Reader["cname"].ToString();
courierExample.cremark = Reader["cremark"] == DBNull.Value ? null : Reader["cremark"].ToString();
courierExample.csort = Reader["csort"] == DBNull.Value ? 0 : (int)Reader["csort"];
return(courierExample);
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
string name = txt_name.Text.Trim();
string remark = txt_remark.Text.Trim();
string sort = txt_sort.Text.Trim();
int temp_sort = 0;
if (!int.TryParse(sort, out temp_sort))
{
Manager.Alert("请输入正确的排序", Page);
return;
}
courier dp = new courier();
if (!string.IsNullOrEmpty(id))
{
dp = BLL.courierManager.SearchByID(Convert.ToInt32(id));
}
dp.cname = name;
dp.cremark = remark;
dp.csort = temp_sort;
int res;
if (string.IsNullOrEmpty(id))
{
res = BLL.courierManager.Insert(dp);
}
else
{
res = BLL.courierManager.Update(dp);
}
if (res == 1)
{
Manager.Alert("保存成功", Page);
}
else
{
Manager.Alert("保存失败", Page);
}
}
catch (Exception ex)
{
Manager.Alert(ex.ToString(), Page);
}
Manager.page_href_reload(Page);
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <courier> SearchAll()
{
Access.DBHelper.sqlstr = "select * from courier order by csort asc ";
List <courier> list = new List <courier>();
OleDbDataReader reader = Access.DBHelper.ExecuteReader();
while (reader.Read())
{
courier Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
public bool Deletecourier(long courier_id)
{
try
{
courier oCourier = _entities.couriers.FirstOrDefault(c => c.courier_id == courier_id);
_entities.couriers.Attach(oCourier);
_entities.couriers.Remove(oCourier);
_entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Editcourier(courier courier)
{
try
{
courier cr = _entities.couriers.Find(courier.courier_id);
cr.courier_name = courier.courier_name;
cr.cell = courier.cell;
_entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// 根据cid,查询一条数据
/// </summary>
/// <param name="cid">快递编号</param>
/// <returns></returns>
public courier SearchByID(int cid)
{
Access.DBHelper.sqlstr = "select * from courier where cid = @cid";
OleDbParameter[] param = new OleDbParameter[] {
new OleDbParameter("@cid", cid)
};
OleDbDataReader reader = Access.DBHelper.ExecuteReader(param);
courier Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
public HttpResponseMessage Post([FromBody] Models.courier courier)
{
try
{
if (string.IsNullOrEmpty(courier.courier_name))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Courier is Empty"
}, formatter));
}
else
{
if (courierRepository.CheckDuplicateCouriers(courier.courier_name))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Courier Already Exists"
}, formatter));
}
else
{
courier insert_brand = new courier
{
courier_name = courier.courier_name,
cell = courier.cell
};
courierRepository.AddCourier(insert_brand);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Courier saved successfully"
}, formatter));
}
}
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
public long AddCourier(courier courier)
{
try
{
courier insert_courier = new courier
{
courier_name = courier.courier_name,
cell = courier.cell
};
_entities.couriers.Add(insert_courier);
_entities.SaveChanges();
long last_insert_id = insert_courier.courier_id;
return(last_insert_id);
}
catch (Exception ex)
{
return(0);
}
}
void bind()
{
if (!string.IsNullOrEmpty(id))
{
int temp = 0;
if (int.TryParse(id, out temp))
{
courier dp = courierManager.SearchByID(temp);
if (dp != null)
{
try
{
txt_name.Text = dp.cname;
txt_remark.Text = dp.cremark;
txt_sort.Text = dp.csort.ToString();
}
catch { }
}
}
}
}
/// <summary>
/// 根据表,获取一个OleDbParameter数组
/// </summary>
/// <returns>OleDbParameter[]</returns>
public static OleDbParameter[] GetOleDbParameter(courier courierExample)
{
List <OleDbParameter> list_param = new List <OleDbParameter>();
if (!string.IsNullOrEmpty(courierExample.cname))
{
list_param.Add(new OleDbParameter("@cname", courierExample.cname));
}
else
{
list_param.Add(new OleDbParameter("@cname", DBNull.Value));
}
if (!string.IsNullOrEmpty(courierExample.cremark))
{
list_param.Add(new OleDbParameter("@cremark", courierExample.cremark));
}
else
{
list_param.Add(new OleDbParameter("@cremark", DBNull.Value));
}
if (courierExample.csort != 0)
{
list_param.Add(new OleDbParameter("@csort", courierExample.csort));
}
else
{
list_param.Add(new OleDbParameter("@csort", DBNull.Value));
}
OleDbParameter[] param = new OleDbParameter[list_param.Count];
int index = 0;
foreach (OleDbParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="courier">courier表实例</param>
/// <returns>int</returns>
public static int Update(courier courierExample)
{
return(Service.Update(courierExample));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="courier">courier表实例</param>
/// <returns>int</returns>
public static int Insert(courier courierExample)
{
return(Service.Insert(courierExample));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="courier">courier表实例</param>
/// <returns>int</returns>
public int Update(courier courierExample)
{
Access.DBHelper.sqlstr = "update courier set cname=@cname,cremark=@cremark,csort=@csort where cid=" + courierExample.cid;
return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(courierExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="courier">courier表实例</param>
/// <returns>int</returns>
public int Insert(courier courierExample)
{
Access.DBHelper.sqlstr = "insert into courier (cname,cremark,csort)values(@cname,@cremark,@csort)";
return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(courierExample)));
}
