protected void GridView3_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txt_account = GridView3.Rows[e.RowIndex].FindControl("txt_account") as TextBox;
TextBox txt_zhifubao = GridView3.Rows[e.RowIndex].FindControl("txt_zhifubao") as TextBox;
TextBox txt_num = GridView3.Rows[e.RowIndex].FindControl("txt_num") as TextBox;
TextBox txt_remark = GridView3.Rows[e.RowIndex].FindControl("txt_remark") as TextBox;
int id = Convert.ToInt32(GridView3.DataKeys[e.RowIndex].Values["fx_id"]);
fanxian fx = BLL.fanxianManager.SearchByfx_id(id);
fx.fx_num = Convert.ToDecimal(txt_num.Text.Trim());
fx.fx_remark = txt_remark.Text.Trim();
fx.fx_zhifubao = txt_zhifubao.Text.Trim();
fx.fx_account = txt_account.Text.Trim();
if (BLL.fanxianManager.Update(fx) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
GridView3.EditIndex = -1;
bind_fanxian();
}
}
/// <summary>
/// 模糊搜索
/// </summary>
/// <param name="key">关键词</param>
/// <param name="state">状态</param>
/// <param name="startdate">起始时间</param>
/// <param name="enddate">结束时间</param>
/// <param name="orderby">排序</param>
/// <returns></returns>
public IList <fanxian> Search(int s, int e, string key, string state, int dpid, DateTime startdate, DateTime enddate, DateTime startdate2, DateTime enddate2, string orderby)
{
string sql1 = "select top " + (e - s + 1).ToString() + " * from fanxian where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( fx_account like '%" + key + "%' or fx_remark like '%" + key + "%' or fx_zhifubao like '%" + key + "%' or fx_num like '" + key + "' ) ";
string sql3 = string.IsNullOrEmpty(state) ? "" : " and fx_state= '" + state + "' ";
string sql9 = dpid == 0 ? "" : " and dpid='" + dpid.ToString() + "' ";
string sql4 = startdate == new DateTime() ? "" : " and datediff(d,'" + startdate.ToString() + "',fx_date)>=0 ";
string sql5 = enddate == new DateTime() ? "" : " and datediff(d,'" + enddate.ToString() + "',fx_date)<=0 ";
string sql6 = startdate2 == new DateTime() ? "" : " and datediff(d,'" + startdate2.ToString() + "',fx_date2)>=0 ";
string sql7 = enddate2 == new DateTime() ? "" : " and datediff(d,'" + enddate2.ToString() + "',fx_date2)<=0 ";
string sql8 = string.IsNullOrEmpty(orderby) ? " order by fx_date desc " : " order by " + orderby;
string sql10 = s == 1 ? "" : " and fx_id not in ( select top " + (s - 1).ToString() + " fx_id from fanxian where " + sql2 + sql3 + sql4 + sql5 + sql7 + sql9 + sql8 + " ) ";
DBHelper.sqlstr = sql1 + sql2 + sql3 + sql9 + sql4 + sql5 + sql6 + sql7 + sql9 + sql10 + sql8;
List <fanxian> list = new List <fanxian>();
SqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
fanxian Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
protected void btn_do_Click(object sender, EventArgs e)
{
string key = txt_key.Text.Trim();
if (string.IsNullOrEmpty(key))
{
AJAXManager.Alert(UpdatePanel1, "请输入关键词");
txt_key.Focus();
return;
}
IList <fanxian> list = BLL.fanxianManager.Search(1, 1, key, "", 0, new DateTime(), new DateTime(), new DateTime(), new DateTime(), "");
if (list.Count > 0)
{
fanxian fx = (fanxian)list[0];
if (fx != null)
{
fx.fx_remark = "支付宝打款失败";
fx.fx_state = "3";
if (BLL.fanxianManager.Update(fx) == 1)
{
AJAXManager.Alert(UpdatePanel1, "处理成功");
return;
}
else
{
AJAXManager.Alert(UpdatePanel1, "处理失败");
return;
}
}
}
AJAXManager.Alert(UpdatePanel1, "没有找到数据");
}
/// <summary>
/// 模糊搜索
/// </summary>
/// <param name="startindex">开始查询位置</param>
/// <param name="searchnum">需要查询的条数</param>
/// <param name="key">关键词</param>
/// <param name="state">状态</param>
/// <param name="id">int字段</param>
/// <param name="startdate">起始时间</param>
/// <param name="enddate">结束时间</param>
/// <param name="orderby">排序</param>
/// <returns>IList<fanxian></returns>
public IList <fanxian> Search(int startindex, int searchnum, string key, string state, int dpid, DateTime startdate, DateTime enddate, DateTime startdate2, DateTime enddate2, string orderby)
{
string sql1 = "select * from fanxian where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( fx_account like '%" + key + "%' or fx_remark like '%" + key + "%' or fx_zhifubao like '%" + key + "%' or fx_num like '" + key + "' ) ";
string sql3 = string.IsNullOrEmpty(state) ? "" : " and fx_state= '" + state + "' "; //状态字段，无用删除
string sql4 = dpid == 0 ? "" : " and dpid='" + dpid.ToString() + "' "; //Int字段，无用删除
string sql5 = startdate == new DateTime() ? "" : " and datediff('" + startdate.ToString() + "',fx_date)>=0 ";
string sql6 = enddate == new DateTime() ? "" : " and datediff('" + enddate.ToString() + "',fx_date)<=0 ";
string sql7 = startdate2 == new DateTime() ? "" : " and datediff('" + startdate2.ToString() + "',fx_date2)>=0 ";
string sql8 = enddate2 == new DateTime() ? "" : " and datediff('" + enddate2.ToString() + "',fx_date2)<=0 ";
string sql9 = string.IsNullOrEmpty(orderby) ? " order by fx_date desc " : " order by " + orderby;
string sql10 = searchnum == 0 ? " " : " limit " + startindex + "," + searchnum;
DBHelper.sqlstr = sql1 + sql2 + sql3 + sql4 + sql5 + sql6 + sql7 + sql8 + sql9 + sql10;
List <fanxian> list = new List <fanxian>();
MySqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
fanxian Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
void bind()
{
if (!string.IsNullOrEmpty(id))
{
int temp = 0;
if (int.TryParse(id, out temp))
{
fanxian fx = fanxianManager.SearchByfx_id(temp);
if (fx != null)
{
try
{
txt_account.Text = fx.fx_account;
txt_remark.Text = fx.fx_remark;
txt_num.Text = fx.fx_num.ToString();
txt_zhifubao.Text = fx.fx_zhifubao;
lbl_date1.Text = fx.fx_date.ToString();
lbl_date2.Text = fx.fx_date2.ToString();
ddl_dianpu.SelectedValue = fx.dpid.ToString();
ddl_state.SelectedValue = fx.fx_state;
}
catch { }
}
}
}
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <fanxian> SearchAll()
{
DBHelper.sqlstr = "select * from fanxian where fx_state='1' order by fx_date desc,fx_id asc ";
List <fanxian> list = new List <fanxian>();
OleDbDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
fanxian Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
/// <summary>
/// 模糊搜索
/// </summary>
/// <param name="key">关键词</param>
/// <param name="state">状态</param>
/// <param name="startdate">起始时间</param>
/// <param name="enddate">结束时间</param>
/// <param name="orderby">排序</param>
/// <returns></returns>
public fanxian SearchLast_FanxianDate()
{
string sql1 = "SELECT top 1 * FROM fanxian order by fx_date2 desc ";
DBHelper.sqlstr = sql1;
OleDbDataReader reader = DBHelper.ExecuteReader();
fanxian Obj = null;
while (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
/// <summary>
/// 从一个OleDbDataReader里读数据
/// </summary>
/// <param name="Reader">OleDbDataReader</param>
/// <returns>fanxianExample</returns>
public static fanxian GetByReader(OleDbDataReader Reader)
{
fanxian fanxianExample = new fanxian();
fanxianExample.dpid = Reader["dpid"] == DBNull.Value ? null : Reader["dpid"].ToString();
fanxianExample.fx_account = Reader["fx_account"] == DBNull.Value ? null : Reader["fx_account"].ToString();
fanxianExample.fx_date = Reader["fx_date"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["fx_date"]);
fanxianExample.fx_date2 = Reader["fx_date2"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["fx_date2"]);
fanxianExample.fx_id = Reader["fx_id"] == DBNull.Value ? 0 : (int)Reader["fx_id"];
fanxianExample.fx_num = Reader["fx_num"] == DBNull.Value ? 0 : Convert.ToDecimal(Reader["fx_num"]);
fanxianExample.fx_remark = Reader["fx_remark"] == DBNull.Value ? null : Reader["fx_remark"].ToString();
fanxianExample.fx_state = Reader["fx_state"] == DBNull.Value ? null : Reader["fx_state"].ToString();
fanxianExample.fx_zhifubao = Reader["fx_zhifubao"] == DBNull.Value ? null : Reader["fx_zhifubao"].ToString();
return(fanxianExample);
}
/// <summary>
/// 根据fx_id,查询一条数据
/// </summary>
/// <param name="fx_id"></param>
/// <returns></returns>
public fanxian SearchByfx_id(int fx_id)
{
DBHelper.sqlstr = "select * from fanxian where fx_id = @fx_id";
OleDbParameter[] param = new OleDbParameter[] {
new OleDbParameter("@fx_id", fx_id)
};
OleDbDataReader reader = DBHelper.ExecuteReader(param);
fanxian Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)
{
string state = e.CommandName;
if (state == "state")
{
int id = Convert.ToInt32(GridView3.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["fx_id"].ToString());
if (id != 0)
{
fanxian fx = BLL.fanxianManager.SearchByfx_id(id);
fx.fx_state = fx.fx_state == "1" ? "2" : (fx.fx_state == "2" ? "3" : "1");
if (fx.fx_state == "2")
{
fx.fx_date2 = DateTime.Now;
}
if (BLL.fanxianManager.Update(fx) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
bind_fanxian();
}
}
}
else if (state == "fanxian")
{
int id = Convert.ToInt32(GridView3.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["fx_id"].ToString());
if (id != 0)
{
fanxian fx = BLL.fanxianManager.SearchByfx_id(id);
fx.fx_state = "2";
fx.fx_date2 = DateTime.Now;
if (BLL.fanxianManager.Update(fx) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
bind_fanxian();
}
//AJAXManager.Alert(UpdatePanel1, "test");
//AJAXManager.Js(UpdatePanel1, "to_zhifubao('" + fx.fx_zhifubao + "','" + fx.fx_num + "')");
}
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
DateTime dt = DateTime.Now;
string num = txt_num.Text.Trim();
string remark = txt_remark.Text.Trim();
string state = ddl_state.SelectedValue.ToString();
string dianpu = ddl_dianpu.SelectedValue != null?ddl_dianpu.SelectedValue.ToString() : "";
string data = txt_data.Text;
//data=data.Replace("\t","");
fanxian fx = new fanxian();
fx.fx_date = DateTime.Now;
int res1 = 0;
int res2 = 0;
decimal temp_num;
if (!decimal.TryParse(num, out temp_num))
{
Manager.Alert("请输入正确的金额", Page);
Manager.TextBox_Select(txt_num);
return;
}
fx.dpid = dianpu;
fx.fx_num = temp_num;
fx.fx_remark = remark;
fx.fx_state = state;
//批量数据处理
string[] ss = data.Split(new char[2] {
'\n', '\r'
}, StringSplitOptions.RemoveEmptyEntries);
foreach (string s in ss)
{
string[] arry = Regex.Split(s, "\\s+", RegexOptions.IgnoreCase);
int i = 1;
List <string> arry2 = new List <string>();
foreach (string temp in arry)
{
if (!string.IsNullOrEmpty(temp))
{
arry2.Add(temp);
}
}
foreach (string temp in arry2)
{
if (i == 1)
{
fx.fx_account = temp;
}
else if (i == 2)
{
fx.fx_zhifubao = temp;
}
i++;
}
if (string.IsNullOrEmpty(fx.fx_account) || string.IsNullOrEmpty(fx.fx_zhifubao))
{
continue;
}
if (BLL.fanxianManager.Insert(fx) == 1)
{
res1++;
}
else
{
res2++;
}
fx.fx_account = "";
fx.fx_zhifubao = "";
}
Manager.Alert("批处理操作完成:\\n成功添加 " + res1.ToString() + " 条信息" + (res2 == 0 ? "" : "\\n添加失败" + res2.ToString() + "条信息！请注意核实！"), Page);
}
catch (Exception ex)
{
Manager.Alert(ex.ToString(), Page);
}
Manager.page_href_reload(Page);
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="fanxian">fanxian表实例</param>
/// <returns>int</returns>
public static int Insert(fanxian fanxianExample)
{
return(Service.Insert(fanxianExample));
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
int temp = e.ColumnIndex;
string id = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
int idid;
if (temp == 4)
{
if (int.TryParse(id, out idid))
{
fanxian fx = BLL2.fanxianManager.SearchByfx_id(idid);
if (fx.fx_state == "1")
{
fx.fx_state = fx.fx_state == "1" ? "2" : "1";
fx.fx_date2 = DateTime.Now;
if (BLL2.fanxianManager.Update(fx) == 1)
{
if (fx.fx_state == "1")
{
dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "未返现";
}
else if (fx.fx_state == "2")
{
dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "已返现";
}
}
else
{
MessageBox.Show("系统出错，请联系我");
}
}
else
{
MessageBox.Show("该返现已经处理，请慎重操作！");
}
}
}
else if (temp == 0)
{
//object kdcode = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
//if (kdcode != null)
//{
// if (!string.IsNullOrEmpty(kdcode.ToString()))
// {
// System.Diagnostics.Process.Start("http://www.kiees.cn/yto.php?wen=" + kdcode);
// }
//}
}
else
{
if (int.TryParse(id, out idid))
{
Entity.fanxian sh = BLL2.fanxianManager.SearchByfx_id(idid);
txt_account.Text = sh.fx_account;
txt_remark.Text = sh.fx_remark;
lbl_id.Text = sh.fx_id.ToString();
lbl_date1.Text = sh.fx_date.ToString();
lbl_date2.Text = sh.fx_date2.ToString();
lbl_CellIndex.Text = e.ColumnIndex.ToString();
lbl_RowIndex.Text = e.RowIndex.ToString();
txt_zhifubao.Text = sh.fx_zhifubao;
try
{
int i = 1;
int.TryParse(sh.dpid, out i);
cb_dianpu.SelectedValue = i;
cb_state.Text = sh.fx_state == "1" ? "未返现" : "已返现";
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
}
}
}
private void btn_save_Click(object sender, EventArgs e)
{
try
{
string id = lbl_id.Text.Trim();
string account = txt_account.Text.Trim();
string num = txt_num.Text.Trim();
string zhifubao = txt_zhifubao.Text.Trim();
string remark = txt_remark.Text.Trim();
string dianpu = cb_dianpu.SelectedValue != null?cb_dianpu.SelectedValue.ToString() : "";
string state = cb_state.Text == "未返现" ? "1" : "2";
int num_temp = 2;
fanxian fx = new fanxian();
if (!string.IsNullOrEmpty(id))
{
fx = BLL2.fanxianManager.SearchByfx_id(Convert.ToInt32(id));
}
if (string.IsNullOrEmpty(zhifubao))
{
MessageBox.Show("请输入支付宝账号！");
txt_zhifubao.Focus();
return;
}
if (string.IsNullOrEmpty(num))
{
MessageBox.Show("请输入返现金额！");
txt_num.Focus();
return;
}
else if (!int.TryParse(num, out num_temp))
{
MessageBox.Show("请输入正确的返现金额！");
txt_num.Focus();
txt_num.SelectAll();
return;
}
if (string.IsNullOrEmpty(dianpu))
{
MessageBox.Show("请选择店铺！");
cb_dianpu.Focus();
return;
}
fx.dpid = dianpu;
fx.fx_account = account;
fx.fx_num = num_temp;
fx.fx_remark = remark;
fx.fx_state = state;
fx.fx_zhifubao = zhifubao;
int res = 0;
if (string.IsNullOrEmpty(lbl_id.Text.Trim()))
{
fx.fx_date = DateTime.Now;
res = BLL2.fanxianManager.Insert(fx);
bind();
}
else
{
string rIndex = lbl_RowIndex.Text.Trim();
string cIndex = lbl_CellIndex.Text.Trim();
int ci;
int ri;
if (int.TryParse(cIndex, out ci) && int.TryParse(rIndex, out ri))
{
string temp_state = dataGridView1.Rows[ri].Cells[4].Value.ToString();
if (temp_state == "1" && fx.fx_state == "2")
{
fx.fx_date2 = DateTime.Now;
}
res = BLL2.fanxianManager.Update(fx);
if (res == 1)
{
dataGridView1.Rows[ri].Cells[0].Value = fx.fx_id;
dataGridView1.Rows[ri].Cells[1].Value = fx.fx_account;
dataGridView1.Rows[ri].Cells[2].Value = fx.fx_zhifubao;
dataGridView1.Rows[ri].Cells[3].Value = fx.fx_num;
dataGridView1.Rows[ri].Cells[4].Value = fx.fx_state == "1" ? "未返现" : "已返现";
dataGridView1.Rows[ri].Cells[5].Value = fx.fx_remark;
dataGridView1.Rows[ri].Cells[6].Value = fx.fx_date.ToString();
}
}
}
if (res == 1)
{
MessageBox.Show("保存成功");
}
else
{
MessageBox.Show("保存失败");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
clears();
}
/// <summary>
/// 根据表,获取一个OleDbParameter数组
/// </summary>
/// <returns>OleDbParameter[]</returns>
public static OleDbParameter[] GetOleDbParameter(fanxian fanxianExample)
{
List <OleDbParameter> list_param = new List <OleDbParameter>();
if (!string.IsNullOrEmpty(fanxianExample.dpid))
{
list_param.Add(new OleDbParameter("@dpid", fanxianExample.dpid));
}
else
{
list_param.Add(new OleDbParameter("@dpid", DBNull.Value));
}
if (!string.IsNullOrEmpty(fanxianExample.fx_account))
{
list_param.Add(new OleDbParameter("@fx_account", fanxianExample.fx_account));
}
else
{
list_param.Add(new OleDbParameter("@fx_account", DBNull.Value));
}
if (fanxianExample.fx_date != new DateTime() && fanxianExample.fx_date != null)
{
list_param.Add(new OleDbParameter("@fx_date", fanxianExample.fx_date.ToString("yyyy-MM-dd")));
}
else
{
list_param.Add(new OleDbParameter("@fx_date", DBNull.Value));
}
if (fanxianExample.fx_date2 != new DateTime() && fanxianExample.fx_date2 != null)
{
list_param.Add(new OleDbParameter("@fx_date2", fanxianExample.fx_date2.ToString("yyyy-MM-dd")));
}
else
{
list_param.Add(new OleDbParameter("@fx_date2", DBNull.Value));
}
if (fanxianExample.fx_num != new decimal())
{
list_param.Add(new OleDbParameter("@fx_num", fanxianExample.fx_num));
}
else
{
list_param.Add(new OleDbParameter("@fx_num", DBNull.Value));
}
if (!string.IsNullOrEmpty(fanxianExample.fx_remark))
{
list_param.Add(new OleDbParameter("@fx_remark", fanxianExample.fx_remark));
}
else
{
list_param.Add(new OleDbParameter("@fx_remark", DBNull.Value));
}
if (!string.IsNullOrEmpty(fanxianExample.fx_state))
{
list_param.Add(new OleDbParameter("@fx_state", fanxianExample.fx_state));
}
else
{
list_param.Add(new OleDbParameter("@fx_state", DBNull.Value));
}
if (!string.IsNullOrEmpty(fanxianExample.fx_zhifubao))
{
list_param.Add(new OleDbParameter("@fx_zhifubao", fanxianExample.fx_zhifubao));
}
else
{
list_param.Add(new OleDbParameter("@fx_zhifubao", DBNull.Value));
}
OleDbParameter[] param = new OleDbParameter[list_param.Count];
int index = 0;
foreach (OleDbParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
DateTime dt = DateTime.Now;
string account = txt_account.Text.Trim();
string zhifubao = txt_zhifubao.Text.Trim();
string num = txt_num.Text.Trim();
string remark = txt_remark.Text.Trim();
string state = ddl_state.SelectedValue.ToString();
string dianpu = ddl_dianpu.SelectedValue != null?ddl_dianpu.SelectedValue.ToString() : "";
fanxian fx = new fanxian();
if (!string.IsNullOrEmpty(id))
{
fx = BLL.fanxianManager.SearchByfx_id(Convert.ToInt32(id));
if (state == "2")
{
fx.fx_date2 = DateTime.Now;
}
}
else
{
fx.fx_date = DateTime.Now;
}
decimal temp_num;
if (!decimal.TryParse(num, out temp_num))
{
AJAXManager.Alert(UpdatePanel1, "请输入正确的金额");
Manager.TextBox_Select(txt_num);
return;
}
fx.dpid = dianpu;
fx.fx_account = account;
fx.fx_num = temp_num;
fx.fx_remark = remark;
fx.fx_state = state;
fx.fx_zhifubao = zhifubao;
int res;
if (string.IsNullOrEmpty(id))
{
res = BLL.fanxianManager.Insert(fx);
}
else
{
res = BLL.fanxianManager.Update(fx);
}
if (res == 1)
{
AJAXManager.Alert(UpdatePanel1, "保存成功");
if (string.IsNullOrEmpty(id))
{
txt_account.Text = "";
txt_num.Text = "";
txt_remark.Text = "";
txt_zhifubao.Text = "";
}
}
else
{
AJAXManager.Alert(UpdatePanel1, "保存失败");
}
}
catch (Exception ex)
{
AJAXManager.Alert(UpdatePanel1, ex.ToString());
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="fanxian">fanxian表实例</param>
/// <returns>int</returns>
public int Update(fanxian fanxianExample)
{
DBHelper.sqlstr = "update fanxian set dpid=@dpid,fx_account=@fx_account,fx_date='" + fanxianExample.fx_date.ToString() + "',fx_date2='" + fanxianExample.fx_date2.ToString() + "',fx_num=@fx_num,fx_remark=@fx_remark,fx_state=@fx_state,fx_zhifubao=@fx_zhifubao where fx_id=" + fanxianExample.fx_id;
return(DBHelper.ExecuteNonQuery(GetOleDbParameter(fanxianExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="fanxian">fanxian表实例</param>
/// <returns>int</returns>
public int Insert(fanxian fanxianExample)
{
DBHelper.sqlstr = "insert into fanxian (dpid,fx_account,fx_date,fx_date2,fx_num,fx_remark,fx_state,fx_zhifubao)values(@dpid,@fx_account,'" + fanxianExample.fx_date.ToString() + "','" + fanxianExample.fx_date2.ToString() + "',fx_num,@fx_remark,@fx_state,@fx_zhifubao)";
return(DBHelper.ExecuteNonQuery(GetOleDbParameter(fanxianExample)));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="fanxian">fanxian表实例</param>
/// <returns>int</returns>
public static int Update(fanxian fanxianExample)
{
return(Service.Update(fanxianExample));
}
