/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.fms_costitem_dep model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fms_costitem_dep(");
strSql.Append("id,dep_id,code_str,creater,create_time)");
strSql.Append(" values (");
strSql.Append("@id,@dep_id,@code_str,@creater,@create_time)");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@dep_id", MySqlDbType.Int32, 11),
new MySqlParameter("@code_str", MySqlDbType.VarChar, 2000),
new MySqlParameter("@creater", MySqlDbType.VarChar, 255),
new MySqlParameter("@create_time", MySqlDbType.DateTime)
};
parameters[0].Value = model.id;
parameters[1].Value = model.dep_id;
parameters[2].Value = model.code_str;
parameters[3].Value = model.creater;
parameters[4].Value = model.create_time;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_costitem_dep model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_costitem_dep set ");
strSql.Append("dep_id=@dep_id,");
strSql.Append("code_str=@code_str,");
strSql.Append("creater=@creater,");
strSql.Append("create_time=@create_time");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@dep_id", MySqlDbType.Int32, 11),
new MySqlParameter("@code_str", MySqlDbType.VarChar, 2000),
new MySqlParameter("@creater", MySqlDbType.VarChar, 255),
new MySqlParameter("@create_time", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.dep_id;
parameters[1].Value = model.code_str;
parameters[2].Value = model.creater;
parameters[3].Value = model.create_time;
parameters[4].Value = model.id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_supply_bank model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_supply_bank set ");
strSql.Append("factoryId=@factoryId,");
strSql.Append("suppliers_id=@suppliers_id,");
strSql.Append("suppliers_code=@suppliers_code,");
strSql.Append("suppliers_name=@suppliers_name,");
strSql.Append("supply_bank=@supply_bank,");
strSql.Append("supply_bankCode=@supply_bankCode,");
strSql.Append("pay_count=@pay_count,");
strSql.Append("create_Id=@create_Id,");
strSql.Append("create_code=@create_code,");
strSql.Append("create_name=@create_name,");
strSql.Append("create_date=@create_date,");
strSql.Append("Is_stop=@Is_stop");
strSql.Append(" where Id=@Id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@factoryId", MySqlDbType.VarChar, 60),
new MySqlParameter("@suppliers_id", MySqlDbType.Int32, 11),
new MySqlParameter("@suppliers_code", MySqlDbType.VarChar, 60),
new MySqlParameter("@suppliers_name", MySqlDbType.VarChar, 300),
new MySqlParameter("@supply_bank", MySqlDbType.VarChar, 100),
new MySqlParameter("@supply_bankCode", MySqlDbType.VarChar, 60),
new MySqlParameter("@pay_count", MySqlDbType.Int32, 11),
new MySqlParameter("@create_Id", MySqlDbType.Int32, 11),
new MySqlParameter("@create_code", MySqlDbType.VarChar, 60),
new MySqlParameter("@create_name", MySqlDbType.VarChar, 60),
new MySqlParameter("@create_date", MySqlDbType.DateTime),
new MySqlParameter("@Is_stop", MySqlDbType.Int16, 1),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.factoryId;
parameters[1].Value = model.suppliers_id;
parameters[2].Value = model.suppliers_code;
parameters[3].Value = model.suppliers_name;
parameters[4].Value = model.supply_bank;
parameters[5].Value = model.supply_bankCode;
parameters[6].Value = model.pay_count;
parameters[7].Value = model.create_Id;
parameters[8].Value = model.create_code;
parameters[9].Value = model.create_name;
parameters[10].Value = model.create_date;
parameters[11].Value = model.Is_stop;
parameters[12].Value = model.Id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_kuan_adjust model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_kuan_adjust set ");
strSql.Append("date_time=@date_time,");
strSql.Append("customer_id=@customer_id,");
strSql.Append("user_id=@user_id,");
strSql.Append("change_total=@change_total,");
strSql.Append("change_type=@change_type,");
strSql.Append("change_desc=@change_desc,");
strSql.Append("admin_id=@admin_id,");
strSql.Append("erp_dakuanhao=@erp_dakuanhao,");
strSql.Append("erp_time=@erp_time,");
strSql.Append("status=@status");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@date_time", MySqlDbType.Int32, 11),
new MySqlParameter("@customer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@change_total", MySqlDbType.Decimal, 10),
new MySqlParameter("@change_type", MySqlDbType.Int16, 2),
new MySqlParameter("@change_desc", MySqlDbType.VarChar, 255),
new MySqlParameter("@admin_id", MySqlDbType.VarChar, 10),
new MySqlParameter("@erp_dakuanhao", MySqlDbType.VarChar, 32),
new MySqlParameter("@erp_time", MySqlDbType.Int32, 11),
new MySqlParameter("@status", MySqlDbType.Int16, 2),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.date_time;
parameters[1].Value = model.customer_id;
parameters[2].Value = model.user_id;
parameters[3].Value = model.change_total;
parameters[4].Value = model.change_type;
parameters[5].Value = model.change_desc;
parameters[6].Value = model.admin_id;
parameters[7].Value = model.erp_dakuanhao;
parameters[8].Value = model.erp_time;
parameters[9].Value = model.status;
parameters[10].Value = model.id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.fms_ac_period model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fms_ac_period(");
strSql.Append("Id,Factory_Id,C_customerid,C_customer_code,C_customername,C_userid,C_username,period_year,period_start,period_end,period_start_date,period_end_date,Is_stop,C_type)");
strSql.Append(" values (");
strSql.Append("@Id,@Factory_Id,@C_customerid,@C_customer_code,@C_customername,@C_userid,@C_username,@period_year,@period_start,@period_end,@period_start_date,@period_end_date,@Is_stop,@C_type)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32, 11),
new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60),
new MySqlParameter("@C_customerid", MySqlDbType.Int32, 11),
new MySqlParameter("@C_customer_code", MySqlDbType.VarChar, 60),
new MySqlParameter("@C_customername", MySqlDbType.VarChar, 200),
new MySqlParameter("@C_userid", MySqlDbType.Int32, 11),
new MySqlParameter("@C_username", MySqlDbType.VarChar, 60),
new MySqlParameter("@period_year", MySqlDbType.VarChar, 4),
new MySqlParameter("@period_start", MySqlDbType.Decimal, 18),
new MySqlParameter("@period_end", MySqlDbType.Decimal, 18),
new MySqlParameter("@period_start_date", MySqlDbType.DateTime),
new MySqlParameter("@period_end_date", MySqlDbType.DateTime),
new MySqlParameter("@Is_stop", MySqlDbType.Int16, 1),
new MySqlParameter("@C_type", MySqlDbType.Int16, 1)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.Factory_Id;
parameters[2].Value = model.C_customerid;
parameters[3].Value = model.C_customer_code;
parameters[4].Value = model.C_customername;
parameters[5].Value = model.C_userid;
parameters[6].Value = model.C_username;
parameters[7].Value = model.period_year;
parameters[8].Value = model.period_start;
parameters[9].Value = model.period_end;
parameters[10].Value = model.period_start_date;
parameters[11].Value = model.period_end_date;
parameters[12].Value = model.Is_stop;
parameters[13].Value = model.C_type;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.fms_supply_bank model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fms_supply_bank(");
strSql.Append("Id,factoryId,suppliers_id,suppliers_code,suppliers_name,supply_bank,supply_bankCode,pay_count,create_Id,create_code,create_name,create_date,Is_stop)");
strSql.Append(" values (");
strSql.Append("@Id,@factoryId,@suppliers_id,@suppliers_code,@suppliers_name,@supply_bank,@supply_bankCode,@pay_count,@create_Id,@create_code,@create_name,@create_date,@Is_stop)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32, 11),
new MySqlParameter("@factoryId", MySqlDbType.VarChar, 60),
new MySqlParameter("@suppliers_id", MySqlDbType.Int32, 11),
new MySqlParameter("@suppliers_code", MySqlDbType.VarChar, 60),
new MySqlParameter("@suppliers_name", MySqlDbType.VarChar, 300),
new MySqlParameter("@supply_bank", MySqlDbType.VarChar, 100),
new MySqlParameter("@supply_bankCode", MySqlDbType.VarChar, 60),
new MySqlParameter("@pay_count", MySqlDbType.Int32, 11),
new MySqlParameter("@create_Id", MySqlDbType.Int32, 11),
new MySqlParameter("@create_code", MySqlDbType.VarChar, 60),
new MySqlParameter("@create_name", MySqlDbType.VarChar, 60),
new MySqlParameter("@create_date", MySqlDbType.DateTime),
new MySqlParameter("@Is_stop", MySqlDbType.Int16, 1)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.factoryId;
parameters[2].Value = model.suppliers_id;
parameters[3].Value = model.suppliers_code;
parameters[4].Value = model.suppliers_name;
parameters[5].Value = model.supply_bank;
parameters[6].Value = model.supply_bankCode;
parameters[7].Value = model.pay_count;
parameters[8].Value = model.create_Id;
parameters[9].Value = model.create_code;
parameters[10].Value = model.create_name;
parameters[11].Value = model.create_date;
parameters[12].Value = model.Is_stop;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Updates(FMS_Model.fms_refund_bill model)
{
string strSql = string.Format(@" update fms_refund_bill set kingdee_in_code='{0}',kingdee_out_code='{1}',kingdee_current_account='{2}', send_out_reason='{3}' where refund_id='{4}'",
model.kingdee_in_code, model.kingdee_out_code, model.kingdee_current_account, model.send_out_reason, model.refund_id);
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Hand(FMS_Model.fms_dkmassage model)
{
string strSql = string.Format(@" update fms_dkmassage set kingdee_out_code='{0}',is_bill_handle='{1}' where id='{2}'",
model.kingdee_out_code, model.is_bill_handle, model.id);
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string idlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update fms_dkmassage set is_delete='1' ");
strSql.Append(" where id in (" + idlist + ") ");
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 付款
/// </summary>
public bool pay_kuan(FMS_Model.fms_refund_bill model, string idList)
{
string strSql = string.Format(@" update fms_refund_bill set refund_status='{0}',pay_id='{1}',pay_code='{2}',pay_name='{3}',pay_date='{4}',
pay_method='{5}',pay_method_name='{6}',is_send_out='{7}' where refund_id in ({8})",
10, model.pay_id, model.pay_code, model.pay_name, model.pay_date, model.pay_method, model.pay_method_name, model.is_send_out, idList);
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string Idlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from fms_ac_period ");
strSql.Append(" where Id in (" + Idlist + ") ");
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool updateHao(string hao, int id)
{
string strSql = string.Empty;
strSql = string.Format(@"update fms_kuan_adjust set erp_dakuanhao='{0}' where id='{1}'", hao, id);
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_refund_log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_refund_log set ");
strSql.Append("refund_id=@refund_id,");
strSql.Append("refund_sn=@refund_sn,");
strSql.Append("emp_id=@emp_id,");
strSql.Append("emp_code=@emp_code,");
strSql.Append("emp_name=@emp_name,");
strSql.Append("log_info=@log_info,");
strSql.Append("log_time=@log_time");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@refund_id", MySqlDbType.Int32, 11),
new MySqlParameter("@refund_sn", MySqlDbType.VarChar, 20),
new MySqlParameter("@emp_id", MySqlDbType.Int32, 11),
new MySqlParameter("@emp_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@emp_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@log_info", MySqlDbType.VarChar, 500),
new MySqlParameter("@log_time", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32, 20)
};
parameters[0].Value = model.refund_id;
parameters[1].Value = model.refund_sn;
parameters[2].Value = model.emp_id;
parameters[3].Value = model.emp_code;
parameters[4].Value = model.emp_name;
parameters[5].Value = model.log_info;
parameters[6].Value = model.log_time;
parameters[7].Value = model.id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Updatee(FMS_Model.fms_dkmassage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_dkmassage set ");
strSql.Append("user_id=@user_id,");
strSql.Append("stats=@stats,");
strSql.Append("erp_dakuanhao=@erp_dakuanhao,");
strSql.Append("confirm_admin_id=@confirm_admin_id,");
strSql.Append("confirm_time=@confirm_time,");
strSql.Append("erp_time=@erp_time");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@stats", MySqlDbType.VarChar, 2),
new MySqlParameter("@erp_dakuanhao", MySqlDbType.VarChar, 32),
new MySqlParameter("@confirm_admin_id", MySqlDbType.Int32, 11),
new MySqlParameter("@confirm_time", MySqlDbType.DateTime),
new MySqlParameter("@erp_time", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.stats;
parameters[2].Value = model.erp_dakuanhao;
parameters[3].Value = model.confirm_admin_id;
parameters[4].Value = model.confirm_time;
parameters[5].Value = model.erp_time;
parameters[6].Value = model.id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 审核
/// </summary>
public bool updateStatus(string status, string idList, string remark)
{
string strSql = string.Empty;
//3:一级审批通过;4：一级审批未通过;5:初级审批通过;6：初级审批未通过;
switch (status)
{
case "3": //一级审批通过
strSql = string.Format(@"update fms_kuan_adjust set status='{0}',approvalOne_date='{1}' where id in ({2})", status, DateTime.Now, idList);
break;
case "4": //一级审批未通过;
strSql = string.Format(@"update fms_kuan_adjust set status='{0}',approvalOne_date='{1}',approvalOne_Opinion='{2}' where id in ({3})", status, DateTime.Now, remark, idList);
break;
case "5": //初级审批通过
strSql = string.Format(@"update fms_kuan_adjust set status='{0}',approvalPrimary_date='{1}' where id in ({2})", status, DateTime.Now, idList);;
break;
case "6": //初级审批未通过
strSql = string.Format(@"update fms_kuan_adjust set status='{0}',approvalPrimary_date='{1}',approvalPrimary_Opinion='{2}' where id in ({3})", status, DateTime.Now, remark, idList);;
break;
default:
strSql = string.Format(@"update fms_kuan_adjust set approvalTwo_status='{0}',approvalTwo_date='{1}' where id in ({2})", 1, DateTime.Now, idList);
break;
}
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.fms_refund_log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fms_refund_log(");
strSql.Append("id,refund_id,refund_sn,emp_id,emp_code,emp_name,log_info,log_time)");
strSql.Append(" values (");
strSql.Append("@id,@refund_id,@refund_sn,@emp_id,@emp_code,@emp_name,@log_info,@log_time)");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 20),
new MySqlParameter("@refund_id", MySqlDbType.Int32, 11),
new MySqlParameter("@refund_sn", MySqlDbType.VarChar, 20),
new MySqlParameter("@emp_id", MySqlDbType.Int32, 11),
new MySqlParameter("@emp_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@emp_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@log_info", MySqlDbType.VarChar, 500),
new MySqlParameter("@log_time", MySqlDbType.DateTime)
};
parameters[0].Value = model.id;
parameters[1].Value = model.refund_id;
parameters[2].Value = model.refund_sn;
parameters[3].Value = model.emp_id;
parameters[4].Value = model.emp_code;
parameters[5].Value = model.emp_name;
parameters[6].Value = model.log_info;
parameters[7].Value = model.log_time;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from fms_ac_period ");
strSql.Append(" where Id=@Id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = Id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(long id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from fms_refund_log ");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 20)
};
parameters[0].Value = id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Del(FMS_Model.fms_dkmassage mModel)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_dkmassage set is_delete='1',operate_userId='" + mModel.operate_userId + "',operate_time='" + mModel.operate_time + "'");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = mModel.id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新erp号
/// </summary>
public bool Updates(string id, string erpCode, int time, string debit_account_code, string credit_account_code)
{
string strSql = string.Empty;
if (!string.IsNullOrEmpty(erpCode))
{
strSql = string.Format(@"update fms_kuan_adjust set erp_dakuanhao='{0}',status='{1}',erp_time='{2}',debit_account_code='{3}',credit_account_code='{4}' where id='{5}'", erpCode, 1, time, debit_account_code, credit_account_code, id);
}
else
{
strSql = string.Format(@"update fms_kuan_adjust set status='{0}' where id='{1}'", 2, id);
}
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_ac_period model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_ac_period set ");
strSql.Append("Factory_Id=@Factory_Id,");
strSql.Append("C_customerid=@C_customerid,");
strSql.Append("C_customer_code=@C_customer_code,");
strSql.Append("C_customername=@C_customername,");
strSql.Append("C_userid=@C_userid,");
strSql.Append("C_username=@C_username,");
strSql.Append("period_year=@period_year,");
strSql.Append("period_start=@period_start,");
strSql.Append("period_end=@period_end,");
strSql.Append("period_start_date=@period_start_date,");
strSql.Append("period_end_date=@period_end_date,");
strSql.Append("Is_stop=@Is_stop,");
strSql.Append("C_type=@C_type");
strSql.Append(" where Id=@Id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60),
new MySqlParameter("@C_customerid", MySqlDbType.Int32, 11),
new MySqlParameter("@C_customer_code", MySqlDbType.VarChar, 60),
new MySqlParameter("@C_customername", MySqlDbType.VarChar, 200),
new MySqlParameter("@C_userid", MySqlDbType.Int32, 11),
new MySqlParameter("@C_username", MySqlDbType.VarChar, 60),
new MySqlParameter("@period_year", MySqlDbType.VarChar, 4),
new MySqlParameter("@period_start", MySqlDbType.Decimal, 18),
new MySqlParameter("@period_end", MySqlDbType.Decimal, 18),
new MySqlParameter("@period_start_date", MySqlDbType.DateTime),
new MySqlParameter("@period_end_date", MySqlDbType.DateTime),
new MySqlParameter("@Is_stop", MySqlDbType.Int16, 1),
new MySqlParameter("@C_type", MySqlDbType.Int16, 1),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Factory_Id;
parameters[1].Value = model.C_customerid;
parameters[2].Value = model.C_customer_code;
parameters[3].Value = model.C_customername;
parameters[4].Value = model.C_userid;
parameters[5].Value = model.C_username;
parameters[6].Value = model.period_year;
parameters[7].Value = model.period_start;
parameters[8].Value = model.period_end;
parameters[9].Value = model.period_start_date;
parameters[10].Value = model.period_end_date;
parameters[11].Value = model.Is_stop;
parameters[12].Value = model.C_type;
parameters[13].Value = model.Id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_kuan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_kuan set ");
strSql.Append("jzdate=@jzdate,");
strSql.Append("jytime=@jytime,");
strSql.Append("jiefang=@jiefang,");
strSql.Append("daifang=@daifang,");
strSql.Append("name=@name,");
strSql.Append("number=@number,");
strSql.Append("user_qq=@user_qq,");
strSql.Append("admin_name=@admin_name,");
strSql.Append("admin_id=@admin_id,");
strSql.Append("erp_dakuanhao=@erp_dakuanhao,");
strSql.Append("status=@status,");
strSql.Append("file_time=@file_time,");
strSql.Append("confirm_time=@confirm_time,");
strSql.Append("dkmassage_id=@dkmassage_id,");
strSql.Append("user_id=@user_id,");
strSql.Append("acc_type=@acc_type");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@jzdate", MySqlDbType.VarChar, 50),
new MySqlParameter("@jytime", MySqlDbType.VarChar, 60),
new MySqlParameter("@jiefang", MySqlDbType.VarChar, 20),
new MySqlParameter("@daifang", MySqlDbType.Decimal, 15),
new MySqlParameter("@name", MySqlDbType.VarChar, 100),
new MySqlParameter("@number", MySqlDbType.VarChar, 30),
new MySqlParameter("@user_qq", MySqlDbType.VarChar, 20),
new MySqlParameter("@admin_name", MySqlDbType.VarChar, 25),
new MySqlParameter("@admin_id", MySqlDbType.VarChar, 10),
new MySqlParameter("@erp_dakuanhao", MySqlDbType.VarChar, 32),
new MySqlParameter("@status", MySqlDbType.Int16, 2),
new MySqlParameter("@file_time", MySqlDbType.Int32, 11),
new MySqlParameter("@confirm_time", MySqlDbType.Int32, 11),
new MySqlParameter("@dkmassage_id", MySqlDbType.Int32, 11),
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@acc_type", MySqlDbType.Int16, 2),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.jzdate;
parameters[1].Value = model.jytime;
parameters[2].Value = model.jiefang;
parameters[3].Value = model.daifang;
parameters[4].Value = model.name;
parameters[5].Value = model.number;
parameters[6].Value = model.user_qq;
parameters[7].Value = model.admin_name;
parameters[8].Value = model.admin_id;
parameters[9].Value = model.erp_dakuanhao;
parameters[10].Value = model.status;
parameters[11].Value = model.file_time;
parameters[12].Value = model.confirm_time;
parameters[13].Value = model.dkmassage_id;
parameters[14].Value = model.user_id;
parameters[15].Value = model.acc_type;
parameters[16].Value = model.id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_refund_bill model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_refund_bill set ");
strSql.Append("refund_sn=@refund_sn,");
strSql.Append("refund_type=@refund_type,");
strSql.Append("refund_status=@refund_status,");
strSql.Append("user_id=@user_id,");
strSql.Append("customer_id=@customer_id,");
strSql.Append("customer_name=@customer_name,");
strSql.Append("refund_money=@refund_money,");
strSql.Append("refund_capital_money=@refund_capital_money,");
strSql.Append("refund_remark=@refund_remark,");
strSql.Append("refund_bank_name=@refund_bank_name,");
strSql.Append("refund_bank_account=@refund_bank_account,");
strSql.Append("pay_method=@pay_method,");
strSql.Append("pay_method_name=@pay_method_name,");
strSql.Append("is_send_out=@is_send_out ");
strSql.Append(" where refund_id=@refund_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@refund_sn", MySqlDbType.VarChar, 20),
new MySqlParameter("@refund_type", MySqlDbType.Int16, 2),
new MySqlParameter("@refund_status", MySqlDbType.Int16, 2),
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@customer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@customer_name", MySqlDbType.VarChar, 250),
new MySqlParameter("@refund_money", MySqlDbType.Decimal, 12),
new MySqlParameter("@refund_capital_money", MySqlDbType.VarChar, 200),
new MySqlParameter("@refund_remark", MySqlDbType.VarChar, 500),
new MySqlParameter("@refund_bank_name", MySqlDbType.VarChar, 200),
new MySqlParameter("@refund_bank_account", MySqlDbType.VarChar, 200),
new MySqlParameter("@pay_method", MySqlDbType.VarChar, 100),
new MySqlParameter("@pay_method_name", MySqlDbType.VarChar, 200),
new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2),
new MySqlParameter("@refund_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.refund_sn;
parameters[1].Value = model.refund_type;
parameters[2].Value = model.refund_status;
parameters[3].Value = model.user_id;
parameters[4].Value = model.customer_id;
parameters[5].Value = model.customer_name;
parameters[6].Value = model.refund_money;
parameters[7].Value = model.refund_capital_money;
parameters[8].Value = model.refund_remark;
parameters[9].Value = model.refund_bank_name;
parameters[10].Value = model.refund_bank_account;
parameters[11].Value = model.pay_method;
parameters[12].Value = model.pay_method_name;
parameters[13].Value = model.is_send_out;
parameters[14].Value = model.refund_id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_dkmassage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_dkmassage set ");
strSql.Append("datetime=@datetime,");
strSql.Append("price=@price,");
strSql.Append("account=@account,");
strSql.Append("user_id=@user_id,");
strSql.Append("user_name=@user_name,");
strSql.Append("channel=@channel,");
strSql.Append("deal=@deal,");
strSql.Append("stats=@stats,");
strSql.Append("notes=@notes,");
strSql.Append("is_delete=@is_delete,");
strSql.Append("erp_dakuanhao=@erp_dakuanhao,");
strSql.Append("add_time=@add_time,");
strSql.Append("erp_bank_id=@erp_bank_id,");
strSql.Append("confirm_admin_id=@confirm_admin_id,");
strSql.Append("confirm_time=@confirm_time,");
strSql.Append("erp_time=@erp_time,");
strSql.Append("erp_type=@erp_type,");
strSql.Append("acc_type=@acc_type");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@datetime", MySqlDbType.VarChar, 100),
new MySqlParameter("@price", MySqlDbType.DateTime),
new MySqlParameter("@account", MySqlDbType.VarChar, 100),
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@user_name", MySqlDbType.VarChar, 100),
new MySqlParameter("@channel", MySqlDbType.VarChar, 100),
new MySqlParameter("@deal", MySqlDbType.VarChar, 100),
new MySqlParameter("@stats", MySqlDbType.VarChar, 2),
new MySqlParameter("@notes", MySqlDbType.VarChar, 200),
new MySqlParameter("@is_delete", MySqlDbType.Int16, 1),
new MySqlParameter("@erp_dakuanhao", MySqlDbType.VarChar, 32),
new MySqlParameter("@add_time", MySqlDbType.DateTime),
new MySqlParameter("@erp_bank_id", MySqlDbType.VarChar, 32),
new MySqlParameter("@confirm_admin_id", MySqlDbType.Int32, 11),
new MySqlParameter("@confirm_time", MySqlDbType.DateTime),
new MySqlParameter("@erp_time", MySqlDbType.DateTime),
new MySqlParameter("@erp_type", MySqlDbType.Int16, 2),
new MySqlParameter("@acc_type", MySqlDbType.Int16, 2),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.datetime;
parameters[1].Value = model.price;
parameters[2].Value = model.account;
parameters[3].Value = model.user_id;
parameters[4].Value = model.user_name;
parameters[5].Value = model.channel;
parameters[6].Value = model.deal;
parameters[7].Value = model.stats;
parameters[8].Value = model.notes;
parameters[9].Value = model.is_delete;
parameters[10].Value = model.erp_dakuanhao;
parameters[11].Value = model.add_time;
parameters[12].Value = model.erp_bank_id;
parameters[13].Value = model.confirm_admin_id;
parameters[14].Value = model.confirm_time;
parameters[15].Value = model.erp_time;
parameters[16].Value = model.erp_type;
parameters[17].Value = model.acc_type;
parameters[18].Value = model.id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.fms_bank_list_excel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fms_bank_list_excel(");
strSql.Append("id,collection_bank_id,collection_bank_code,collection_bank_name,collection_account,dk_time,dk_time_only,dk_money,dk_account,dk_username,dk_bank_name,dk_channel,dk_message_remarks,start_line,excel_exist_collection_account,sort,excel_type,is_use,is_show_full,acc_type,is_collect,is_send_out)");
strSql.Append(" values (");
strSql.Append("@id,@collection_bank_id,@collection_bank_code,@collection_bank_name,@collection_account,@dk_time,@dk_time_only,@dk_money,@dk_account,@dk_username,@dk_bank_name,@dk_channel,@dk_message_remarks,@start_line,@excel_exist_collection_account,@sort,@excel_type,@is_use,@is_show_full,@acc_type,@is_collect,@is_send_out)");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@collection_bank_id", MySqlDbType.Int16, 5),
new MySqlParameter("@collection_bank_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@collection_bank_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@collection_account", MySqlDbType.VarChar, 255),
new MySqlParameter("@dk_time", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_time_only", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_money", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_account", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_username", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_bank_name", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_channel", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_message_remarks", MySqlDbType.VarChar, 6),
new MySqlParameter("@start_line", MySqlDbType.Int16, 5),
new MySqlParameter("@excel_exist_collection_account", MySqlDbType.Int16, 2),
new MySqlParameter("@sort", MySqlDbType.Int32, 3),
new MySqlParameter("@excel_type", MySqlDbType.VarChar, 10),
new MySqlParameter("@is_use", MySqlDbType.Int16, 2),
new MySqlParameter("@is_show_full", MySqlDbType.Int16, 2),
new MySqlParameter("@acc_type", MySqlDbType.Int16, 2),
new MySqlParameter("@is_collect", MySqlDbType.Int16, 2),
new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2)
};
parameters[0].Value = model.id;
parameters[1].Value = model.collection_bank_id;
parameters[2].Value = model.collection_bank_code;
parameters[3].Value = model.collection_bank_name;
parameters[4].Value = model.collection_account;
parameters[5].Value = model.dk_time;
parameters[6].Value = model.dk_time_only;
parameters[7].Value = model.dk_money;
parameters[8].Value = model.dk_account;
parameters[9].Value = model.dk_username;
parameters[10].Value = model.dk_bank_name;
parameters[11].Value = model.dk_channel;
parameters[12].Value = model.dk_message_remarks;
parameters[13].Value = model.start_line;
parameters[14].Value = model.excel_exist_collection_account;
parameters[15].Value = model.sort;
parameters[16].Value = model.excel_type;
parameters[17].Value = model.is_use;
parameters[18].Value = model.is_show_full;
parameters[19].Value = model.acc_type;
parameters[20].Value = model.is_collect;
parameters[21].Value = model.is_send_out;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_bank_list_excel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_bank_list_excel set ");
strSql.Append("collection_bank_id=@collection_bank_id,");
strSql.Append("collection_bank_code=@collection_bank_code,");
strSql.Append("collection_bank_name=@collection_bank_name,");
strSql.Append("collection_account=@collection_account,");
strSql.Append("dk_time=@dk_time,");
strSql.Append("dk_time_only=@dk_time_only,");
strSql.Append("dk_money=@dk_money,");
strSql.Append("dk_account=@dk_account,");
strSql.Append("dk_username=@dk_username,");
strSql.Append("dk_bank_name=@dk_bank_name,");
strSql.Append("dk_channel=@dk_channel,");
strSql.Append("dk_message_remarks=@dk_message_remarks,");
strSql.Append("start_line=@start_line,");
strSql.Append("excel_exist_collection_account=@excel_exist_collection_account,");
strSql.Append("sort=@sort,");
strSql.Append("excel_type=@excel_type,");
strSql.Append("is_use=@is_use,");
strSql.Append("is_show_full=@is_show_full,");
strSql.Append("acc_type=@acc_type,");
strSql.Append("is_collect=@is_collect,");
strSql.Append("is_send_out=@is_send_out");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@collection_bank_id", MySqlDbType.Int16, 5),
new MySqlParameter("@collection_bank_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@collection_bank_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@collection_account", MySqlDbType.VarChar, 255),
new MySqlParameter("@dk_time", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_time_only", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_money", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_account", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_username", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_bank_name", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_channel", MySqlDbType.VarChar, 6),
new MySqlParameter("@dk_message_remarks", MySqlDbType.VarChar, 6),
new MySqlParameter("@start_line", MySqlDbType.Int16, 5),
new MySqlParameter("@excel_exist_collection_account", MySqlDbType.Int16, 2),
new MySqlParameter("@sort", MySqlDbType.Int32, 3),
new MySqlParameter("@excel_type", MySqlDbType.VarChar, 10),
new MySqlParameter("@is_use", MySqlDbType.Int16, 2),
new MySqlParameter("@is_show_full", MySqlDbType.Int16, 2),
new MySqlParameter("@acc_type", MySqlDbType.Int16, 2),
new MySqlParameter("@is_collect", MySqlDbType.Int16, 2),
new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.collection_bank_id;
parameters[1].Value = model.collection_bank_code;
parameters[2].Value = model.collection_bank_name;
parameters[3].Value = model.collection_account;
parameters[4].Value = model.dk_time;
parameters[5].Value = model.dk_time_only;
parameters[6].Value = model.dk_money;
parameters[7].Value = model.dk_account;
parameters[8].Value = model.dk_username;
parameters[9].Value = model.dk_bank_name;
parameters[10].Value = model.dk_channel;
parameters[11].Value = model.dk_message_remarks;
parameters[12].Value = model.start_line;
parameters[13].Value = model.excel_exist_collection_account;
parameters[14].Value = model.sort;
parameters[15].Value = model.excel_type;
parameters[16].Value = model.is_use;
parameters[17].Value = model.is_show_full;
parameters[18].Value = model.acc_type;
parameters[19].Value = model.is_collect;
parameters[20].Value = model.is_send_out;
parameters[21].Value = model.id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.fms_refund_bill model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fms_refund_bill(");
strSql.Append("refund_id,refund_sn,refund_type,refund_status,emp_id,emp_code,emp_name,apply_date,user_id,customer_id,customer_name,refund_money,refund_capital_money,refund_remark,refund_bank_name,refund_bank_account,pay_method,pay_method_name,pay_id,pay_code,pay_name,pay_date,approvalOne_id,approvalOne_code,approvalOne_name,approvalOne_date,approvalTwo_id,approvalTwo_code,approvalTwo_name,approvalTwo_date,approvalThree_id,approvalThree_code,approvalThree_name,approvalThree_date,approvalFour_id,approvalFour_code,approvalFour_name,approvalFour_date,is_del,kingdee_current_account,is_send_out,kingdee_in_code,kingdee_out_code,print_num)");
strSql.Append(" values (");
strSql.Append("@refund_id,@refund_sn,@refund_type,@refund_status,@emp_id,@emp_code,@emp_name,@apply_date,@user_id,@customer_id,@customer_name,@refund_money,@refund_capital_money,@refund_remark,@refund_bank_name,@refund_bank_account,@pay_method,@pay_method_name,@pay_id,@pay_code,@pay_name,@pay_date,@approvalOne_id,@approvalOne_code,@approvalOne_name,@approvalOne_date,@approvalTwo_id,@approvalTwo_code,@approvalTwo_name,@approvalTwo_date,@approvalThree_id,@approvalThree_code,@approvalThree_name,@approvalThree_date,@approvalFour_id,@approvalFour_code,@approvalFour_name,@approvalFour_date,@is_del,@kingdee_current_account,@is_send_out,@kingdee_in_code,@kingdee_out_code,@print_num)");
MySqlParameter[] parameters =
{
new MySqlParameter("@refund_id", MySqlDbType.Int32, 11),
new MySqlParameter("@refund_sn", MySqlDbType.VarChar, 20),
new MySqlParameter("@refund_type", MySqlDbType.Int16, 2),
new MySqlParameter("@refund_status", MySqlDbType.Int16, 2),
new MySqlParameter("@emp_id", MySqlDbType.Int32, 11),
new MySqlParameter("@emp_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@emp_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@apply_date", MySqlDbType.DateTime),
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@customer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@customer_name", MySqlDbType.VarChar, 250),
new MySqlParameter("@refund_money", MySqlDbType.Decimal, 12),
new MySqlParameter("@refund_capital_money", MySqlDbType.VarChar, 200),
new MySqlParameter("@refund_remark", MySqlDbType.VarChar, 500),
new MySqlParameter("@refund_bank_name", MySqlDbType.VarChar, 200),
new MySqlParameter("@refund_bank_account", MySqlDbType.VarChar, 200),
new MySqlParameter("@pay_method", MySqlDbType.VarChar, 100),
new MySqlParameter("@pay_method_name", MySqlDbType.VarChar, 200),
new MySqlParameter("@pay_id", MySqlDbType.Int32, 11),
new MySqlParameter("@pay_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@pay_name", MySqlDbType.VarChar, 20),
new MySqlParameter("@pay_date", MySqlDbType.DateTime),
new MySqlParameter("@approvalOne_id", MySqlDbType.Int32, 11),
new MySqlParameter("@approvalOne_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@approvalOne_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@approvalOne_date", MySqlDbType.DateTime),
new MySqlParameter("@approvalTwo_id", MySqlDbType.Int32, 11),
new MySqlParameter("@approvalTwo_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@approvalTwo_name", MySqlDbType.VarChar, 20),
new MySqlParameter("@approvalTwo_date", MySqlDbType.DateTime),
new MySqlParameter("@approvalThree_id", MySqlDbType.Int32, 11),
new MySqlParameter("@approvalThree_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@approvalThree_name", MySqlDbType.VarChar, 20),
new MySqlParameter("@approvalThree_date", MySqlDbType.DateTime),
new MySqlParameter("@approvalFour_id", MySqlDbType.Int32, 11),
new MySqlParameter("@approvalFour_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@approvalFour_name", MySqlDbType.VarChar, 20),
new MySqlParameter("@approvalFour_date", MySqlDbType.DateTime),
new MySqlParameter("@is_del", MySqlDbType.Int16, 2),
new MySqlParameter("@kingdee_current_account", MySqlDbType.VarChar, 100),
new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2),
new MySqlParameter("@kingdee_in_code", MySqlDbType.VarChar, 32),
new MySqlParameter("@kingdee_out_code", MySqlDbType.VarChar, 32),
new MySqlParameter("@print_num", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.refund_id;
parameters[1].Value = model.refund_sn;
parameters[2].Value = model.refund_type;
parameters[3].Value = model.refund_status;
parameters[4].Value = model.emp_id;
parameters[5].Value = model.emp_code;
parameters[6].Value = model.emp_name;
parameters[7].Value = model.apply_date;
parameters[8].Value = model.user_id;
parameters[9].Value = model.customer_id;
parameters[10].Value = model.customer_name;
parameters[11].Value = model.refund_money;
parameters[12].Value = model.refund_capital_money;
parameters[13].Value = model.refund_remark;
parameters[14].Value = model.refund_bank_name;
parameters[15].Value = model.refund_bank_account;
parameters[16].Value = model.pay_method;
parameters[17].Value = model.pay_method_name;
parameters[18].Value = model.pay_id;
parameters[19].Value = model.pay_code;
parameters[20].Value = model.pay_name;
parameters[21].Value = model.pay_date;
parameters[22].Value = model.approvalOne_id;
parameters[23].Value = model.approvalOne_code;
parameters[24].Value = model.approvalOne_name;
parameters[25].Value = model.approvalOne_date;
parameters[26].Value = model.approvalTwo_id;
parameters[27].Value = model.approvalTwo_code;
parameters[28].Value = model.approvalTwo_name;
parameters[29].Value = model.approvalTwo_date;
parameters[30].Value = model.approvalThree_id;
parameters[31].Value = model.approvalThree_code;
parameters[32].Value = model.approvalThree_name;
parameters[33].Value = model.approvalThree_date;
parameters[34].Value = model.approvalFour_id;
parameters[35].Value = model.approvalFour_code;
parameters[36].Value = model.approvalFour_name;
parameters[37].Value = model.approvalFour_date;
parameters[38].Value = model.is_del;
parameters[39].Value = model.kingdee_current_account;
parameters[40].Value = model.is_send_out;
parameters[41].Value = model.kingdee_in_code;
parameters[42].Value = model.kingdee_out_code;
parameters[43].Value = model.print_num;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
