/// <summary>
/// 更新一条数据
/// </summary>
public bool Updates(FMS_Model.fms_kuan model, FMS_Model.fms_dkmassage Mmodel)
{
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
strSql = string.Format(@" update xmh_fms.fms_kuan set erp_dakuanhao='{0}',kingdee_out_code='{1}' where id='{2}' ", model.erp_dakuanhao, model.kingdee_out_code, model.id);
strSqlList.Add(strSql);
strSql = string.Format(@" update xmh_fms.fms_dkmassage set stats='{0}', erp_dakuanhao='{1}',user_id='{2}',kingdee_out_code='{3}',is_send_out='{4}',is_inner_Journal='{5}',send_out_reason='{6}' where id='{7}'",
Mmodel.stats, Mmodel.erp_dakuanhao, Mmodel.user_id, Mmodel.kingdee_out_code, Mmodel.is_send_out, 1, Mmodel.send_out_reason, Mmodel.id);
strSqlList.Add(strSql);
int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows >= 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateJ(FMS_Model.fms_dkmassage Mmodel, int flag)
{
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
if (flag == 0)
{
strSql = string.Format(@" update xmh_fms.fms_dkmassage set is_inner_Journal='{0}' where id='{1}'",
Mmodel.is_inner_Journal, Mmodel.id);
strSqlList.Add(strSql);
}
else if (flag == 1)
{
strSql = string.Format(@" update xmh_fms.fms_dkmassage set is_out_Journal='{0}' where id='{1}'",
Mmodel.is_inner_Journal, Mmodel.id);
strSqlList.Add(strSql);
}
int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows >= 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 重新认款
/// </summary>
public bool KnowKuans(FMS_Model.fms_dkmassage model, FMS_Model.shop_progress_payments progress)
{
fms_kuan kuan = new fms_kuan();
shop_progress_payments _proPayments = new shop_progress_payments();
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
DataSet ds = kuan.GetList(" dkmassage_id='" + model.id + "'");
//已认款、待收款的重新认款
strSql = string.Format(@" update fms_dkmassage set stats='{0}',operate_userId='{1}',operate_time='{2}' where id='{3}'", model.stats, model.operate_userId, model.operate_time, model.id);
strSqlList.Add(strSql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
strSql = string.Format(" Delete from fms_kuan where dkmassage_id='{0}'", model.id);
//strSql = string.Format(" update fms_kuan set status ='{0}'where dkmassage_id='{1}'", 1, model.id);
strSqlList.Add(strSql);
}
//3.shop_progress_payments
DataSet dp = _proPayments.GetLists(" order_sn='" + model.id + "' and type='2' ");
if (dp != null && dp.Tables[0].Rows.Count > 0)
{
strSql = string.Format(" Delete from xmh_shop.shop_progress_payments where order_sn='{0}' and type='{1}' ", model.id, 2);
//strSql = string.Format(" update xmh_shop.shop_progress_payments set status='{0}' where order_sn='{2}'",2, model.id);
strSqlList.Add(strSql);
}
//_proPayments.Add(progress);
//strSqlList.Add(strSql);
int rows = FMS_DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//批量删除
public bool DelAllKuan(string idList, FMS_Model.fms_dkmassage mModel)
{
fms_kuan kuan = new fms_kuan();
shop_progress_payments _proPayments = new shop_progress_payments();
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
DataSet ds = GetList(" id in(" + idList + ")");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
//strSql = string.Format(@" delete from fms_dkmassage where id='{0}'", Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString()));
strSql = string.Format(@" update fms_dkmassage set is_delete='{0}',operate_userId='{1}',operate_time='{2}' where id='{3}'", 1, mModel.operate_userId, mModel.operate_time, Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString()));
strSqlList.Add(strSql);
DataSet dk = kuan.GetList(" dkmassage_id='" + ds.Tables[0].Rows[i]["id"].ToString() + "'");
if (dk != null && dk.Tables[0].Rows.Count > 0)
{
strSql = string.Format(" Delete from fms_kuan where dkmassage_id='{0}'", Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString()));
//strSql = string.Format(" update fms_kuan set status ='{0}'where dkmassage_id='{1}'", 1, Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString()));
strSqlList.Add(strSql);
}
DataSet dp = _proPayments.GetLists(" order_sn='" + ds.Tables[0].Rows[i]["id"].ToString() + "' and type='2' ");
if (dp != null && dp.Tables[0].Rows.Count > 0)
{
strSql = string.Format(" Delete from xmh_shop.shop_progress_payments where order_sn='{0}' and type='{1}'", Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString()), 2);
strSqlList.Add(strSql);
}
}
}
int rows = FMS_DbHelperMySQL.ExecuteSqlTran(strSqlList);
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 KnowKuan(int flag, FMS_Model.fms_dkmassage model)
{
fms_kuan kuan = new fms_kuan();
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
switch (flag)
{
case 1: //认款
strSql = string.Format(@" update fms_dkmassage set user_id='{0}',confirm_admin_id='{1}',confirm_time='{2}',stats='{3}' where id='{4}'",
model.user_id, model.confirm_admin_id, model.confirm_time, model.stats, model.id);
strSqlList.Add(strSql);
break;
case 2: //未确认、待确认的重新认款
DataSet ds = kuan.GetList(" dkmassage_id='" + model.id + "'");
strSql = string.Format(@" update fms_dkmassage set stats='{0}',operate_userId='{1}',operate_time='{2}' where id='{3}'", model.stats, model.operate_userId, model.operate_time, model.id);
strSqlList.Add(strSql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
strSql = string.Format(" update fms_kuan set status ='{0}'where dkmassage_id='{1}'", 1, model.id);
strSqlList.Add(strSql);
}
break;
default:
break;
}
int rows = FMS_DbHelperMySQL.ExecuteSqlTran(strSqlList);
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 UpdateCode(FMS_Model.fms_kuan model, FMS_Model.fms_dkmassage Mmodel)
{
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
strSql = string.Format(@" update xmh_fms.fms_kuan set kingdee_out_code='{0}' where id='{1}' ", model.kingdee_out_code, model.id);
strSqlList.Add(strSql);
strSql = string.Format(@" update xmh_fms.fms_dkmassage set kingdee_out_code='{0}',send_out_reason='{1}' where id='{2}'", Mmodel.kingdee_out_code, Mmodel.send_out_reason, Mmodel.id);
strSqlList.Add(strSql);
int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows >= 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.fms_dkmassage GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,datetime,price,account,user_id,user_name,channel,deal,stats,notes,is_delete,erp_dakuanhao,add_time,erp_bank_id,confirm_admin_id,confirm_time,erp_time,erp_type,acc_type from fms_dkmassage ");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = id;
FMS_Model.fms_dkmassage model = new FMS_Model.fms_dkmassage();
DataSet ds = FMS_DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <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>
/// 增加一条数据
/// </summary>
public bool Adds(FMS_Model.fms_kuan model, FMS_Model.fms_dkmassage Mmodel, FMS_Model.shop_progress_payments pmodel, DataSet ds)
{
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
strSql = string.Format(@" insert into xmh_fms.fms_kuan (jzdate,jytime,jiefang,daifang,name,number,user_qq,admin_name,admin_id,erp_dakuanhao,status,file_time,confirm_time,dkmassage_id,user_id,acc_type)
value('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}') ",
model.jzdate, model.jytime, model.jiefang, model.daifang, model.name, model.number, model.user_qq, model.admin_name, model.admin_id, model.erp_dakuanhao, model.status, model.file_time, model.confirm_time, model.dkmassage_id, model.user_id, model.acc_type);
strSqlList.Add(strSql);
strSql = string.Format(@" update xmh_fms.fms_dkmassage set erp_dakuanhao='{0}',confirm_admin_id='{1}',confirm_time='{2}',erp_time='{3}',user_id='{4}',operate_userId='{5}',operate_time='{6}' where id='{7}'",
Mmodel.erp_dakuanhao, Mmodel.confirm_admin_id, Mmodel.confirm_time, Mmodel.erp_time, Mmodel.user_id, Mmodel.operate_userId, Mmodel.operate_time, Mmodel.id);
strSqlList.Add(strSql);
strSql = string.Format(@" insert into xmh_shop.shop_progress_payments (type,order_sn,add_time,money,user_id,employee_id,emp_code,msg,status,start_valid_time,user_yingshou)
value('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}') ",
pmodel.type, pmodel.order_sn, pmodel.add_time, pmodel.money, pmodel.user_id, pmodel.employee_id, pmodel.emp_code, pmodel.msg, pmodel.status, pmodel.start_valid_time, pmodel.user_yingshou);
strSqlList.Add(strSql);
if (!string.IsNullOrEmpty(Mmodel.account))
{
if (string.IsNullOrEmpty(ds.Tables[0].Rows[0]["bill_bank_code1"].ToString()))
{
strSql = string.Format(@" Update CRM_Contact set bill_bank_code1='{0}' where id='{1}'", Mmodel.account, ds.Tables[0].Rows[0]["id"].ToString());
strSqlList.Add(strSql);
}
else if (string.IsNullOrEmpty(ds.Tables[0].Rows[0]["bill_bank_code2"].ToString()))
{
strSql = string.Format(@" Update CRM_Contact set bill_bank_code2='{0}' where id='{1}'", Mmodel.account, ds.Tables[0].Rows[0]["id"].ToString());
strSqlList.Add(strSql);
}
else if (string.IsNullOrEmpty(ds.Tables[0].Rows[0]["bill_bank_code3"].ToString()))
{
strSql = string.Format(@" Update CRM_Contact set bill_bank_code3='{0}' where id='{1}'", Mmodel.account, ds.Tables[0].Rows[0]["id"].ToString());
strSqlList.Add(strSql);
}
else if (string.IsNullOrEmpty(ds.Tables[0].Rows[0]["bill_bank_code4"].ToString()))
{
strSql = string.Format(@" Update CRM_Contact set bill_bank_code4='{0}' where id='{1}'", Mmodel.account, ds.Tables[0].Rows[0]["id"].ToString());
strSqlList.Add(strSql);
}
else if (string.IsNullOrEmpty(ds.Tables[0].Rows[0]["bill_bank_code5"].ToString()))
{
strSql = string.Format(@" Update CRM_Contact set bill_bank_code5='{0}' where id='{1}'", Mmodel.account, ds.Tables[0].Rows[0]["id"].ToString());
strSqlList.Add(strSql);
}
else if (string.IsNullOrEmpty(ds.Tables[0].Rows[0]["bill_bank_code6"].ToString()))
{
strSql = string.Format(@" Update CRM_Contact set bill_bank_code6='{0}' where id='{1}'", Mmodel.account, ds.Tables[0].Rows[0]["id"].ToString());
strSqlList.Add(strSql);
}
else if (string.IsNullOrEmpty(ds.Tables[0].Rows[0]["bill_alipay_code"].ToString()))
{
strSql = string.Format(@" Update CRM_Contact set bill_alipay_code='{0}' where id='{1}'", Mmodel.account, ds.Tables[0].Rows[0]["id"].ToString());
strSqlList.Add(strSql);
}
else if (string.IsNullOrEmpty(ds.Tables[0].Rows[0]["bill_wei_code"].ToString()))
{
strSql = string.Format(@" Update CRM_Contact set bill_wei_code='{0}' where id='{1}'", Mmodel.account, ds.Tables[0].Rows[0]["id"].ToString());
strSqlList.Add(strSql);
}
}
int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows >= 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.fms_dkmassage DataRowToModel(DataRow row)
{
FMS_Model.fms_dkmassage model = new FMS_Model.fms_dkmassage();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["datetime"] != null && row["datetime"].ToString() != "")
{
model.datetime = DateTime.Parse(row["datetime"].ToString());
}
//if (row["price"] != null)
//{
// model.price = row["price"].ToString();
//}
if (row["account"] != null)
{
model.account = row["account"].ToString();
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["user_name"] != null)
{
model.user_name = row["user_name"].ToString();
}
if (row["channel"] != null)
{
model.channel = row["channel"].ToString();
}
if (row["deal"] != null)
{
model.deal = row["deal"].ToString();
}
if (row["stats"] != null)
{
model.stats = row["stats"].ToString();
}
if (row["notes"] != null)
{
model.notes = row["notes"].ToString();
}
if (row["is_delete"] != null && row["is_delete"].ToString() != "")
{
model.is_delete = int.Parse(row["is_delete"].ToString());
}
if (row["erp_dakuanhao"] != null)
{
model.erp_dakuanhao = row["erp_dakuanhao"].ToString();
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(row["add_time"].ToString());
}
if (row["erp_bank_id"] != null)
{
model.erp_bank_id = row["erp_bank_id"].ToString();
}
if (row["confirm_admin_id"] != null && row["confirm_admin_id"].ToString() != "")
{
model.confirm_admin_id = int.Parse(row["confirm_admin_id"].ToString());
}
if (row["confirm_time"] != null && row["confirm_time"].ToString() != "")
{
model.confirm_time = DateTime.Parse(row["confirm_time"].ToString());
}
if (row["erp_time"] != null && row["erp_time"].ToString() != "")
{
model.erp_time = DateTime.Parse(row["erp_time"].ToString());
}
if (row["erp_type"] != null && row["erp_type"].ToString() != "")
{
model.erp_type = int.Parse(row["erp_type"].ToString());
}
if (row["acc_type"] != null && row["acc_type"].ToString() != "")
{
model.acc_type = int.Parse(row["acc_type"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FMS_Model.fms_dkmassage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fms_dkmassage(");
strSql.Append("id,datetime,price,account,user_id,user_name,channel,deal,stats,notes,is_delete,erp_dakuanhao,add_time,erp_bank_id,confirm_admin_id,confirm_time,erp_time,erp_type,acc_type,kingdee_current_account,is_send_out,kingdee_out_code,from_type,operate_userId,operate_time)");
strSql.Append(" values (");
strSql.Append("@id,@datetime,@price,@account,@user_id,@user_name,@channel,@deal,@stats,@notes,@is_delete,@erp_dakuanhao,@add_time,@erp_bank_id,@confirm_admin_id,@confirm_time,@erp_time,@erp_type,@acc_type,@kingdee_current_account,@is_send_out,@kingdee_out_code,@from_type,@operate_userId,@operate_time)");
strSql.Append(";select @@IDENTITY");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@datetime", MySqlDbType.DateTime),
new MySqlParameter("@price", MySqlDbType.Decimal, 10),
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("@kingdee_current_account", MySqlDbType.VarChar, 100),
new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2),
new MySqlParameter("@kingdee_out_code", MySqlDbType.VarChar, 32),
new MySqlParameter("@from_type", MySqlDbType.Int16, 2),
new MySqlParameter("@operate_userId", MySqlDbType.Int32, 11),
new MySqlParameter("@operate_time", MySqlDbType.DateTime)
};
parameters[0].Value = model.id;
parameters[1].Value = model.datetime;
parameters[2].Value = model.price;
parameters[3].Value = model.account;
parameters[4].Value = model.user_id;
parameters[5].Value = model.user_name;
parameters[6].Value = model.channel;
parameters[7].Value = model.deal;
parameters[8].Value = model.stats;
parameters[9].Value = model.notes;
parameters[10].Value = model.is_delete;
parameters[11].Value = model.erp_dakuanhao;
parameters[12].Value = model.add_time;
parameters[13].Value = model.erp_bank_id;
parameters[14].Value = model.confirm_admin_id;
parameters[15].Value = model.confirm_time;
parameters[16].Value = model.erp_time;
parameters[17].Value = model.erp_type;
parameters[18].Value = model.acc_type;
parameters[19].Value = model.kingdee_current_account;
parameters[20].Value = model.is_send_out;
parameters[21].Value = model.kingdee_out_code;
parameters[22].Value = model.from_type;
parameters[23].Value = model.operate_userId;
parameters[24].Value = model.operate_time;
object obj = FMS_DbHelperMySQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <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);
}
}
