/// <summary> /// 增加一条数据 /// </summary> public bool AddKuan(FMS_Model.fms_kuan model, FMS_Model.shop_progress_payments pmodel) { 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(@" 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); int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList); if (rows >= 0) { return(true); } else { return(false); } }
/// <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 int Add(FMS_Model.fms_kuan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into fms_kuan("); strSql.Append("id,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)"); strSql.Append(" values ("); strSql.Append("@id,@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)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 11), 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) }; parameters[0].Value = model.id; parameters[1].Value = model.jzdate; parameters[2].Value = model.jytime; parameters[3].Value = model.jiefang; parameters[4].Value = model.daifang; parameters[5].Value = model.name; parameters[6].Value = model.number; parameters[7].Value = model.user_qq; parameters[8].Value = model.admin_name; parameters[9].Value = model.admin_id; parameters[10].Value = model.erp_dakuanhao; parameters[11].Value = model.status; parameters[12].Value = model.file_time; parameters[13].Value = model.confirm_time; parameters[14].Value = model.dkmassage_id; parameters[15].Value = model.user_id; parameters[16].Value = model.acc_type; object obj = FMS_DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <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_kuan GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,jzdate,jytime,jiefang,daifang,name,number,user_qq,admin_name,admin_id,erp_dakuanhao,status,file_time,confirm_time,dkmassage_id,user_id from fms_kuan,acc_type "); strSql.Append(" where id=@id "); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = id; FMS_Model.fms_kuan model = new FMS_Model.fms_kuan(); 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 FMS_Model.fms_kuan DataRowToModel(DataRow row) { FMS_Model.fms_kuan model = new FMS_Model.fms_kuan(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["jzdate"] != null) { model.jzdate = row["jzdate"].ToString(); } if (row["jytime"] != null) { model.jytime = row["jytime"].ToString(); } if (row["jiefang"] != null) { model.jiefang = row["jiefang"].ToString(); } if (row["daifang"] != null && row["daifang"].ToString() != "") { model.daifang = decimal.Parse(row["daifang"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["number"] != null) { model.number = row["number"].ToString(); } if (row["user_qq"] != null) { model.user_qq = row["user_qq"].ToString(); } if (row["admin_name"] != null) { model.admin_name = row["admin_name"].ToString(); } if (row["admin_id"] != null) { model.admin_id = row["admin_id"].ToString(); } if (row["erp_dakuanhao"] != null) { model.erp_dakuanhao = row["erp_dakuanhao"].ToString(); } if (row["status"] != null && row["status"].ToString() != "") { model.status = int.Parse(row["status"].ToString()); } if (row["file_time"] != null && row["file_time"].ToString() != "") { model.file_time = int.Parse(row["file_time"].ToString()); } if (row["confirm_time"] != null && row["confirm_time"].ToString() != "") { model.confirm_time = int.Parse(row["confirm_time"].ToString()); } if (row["dkmassage_id"] != null && row["dkmassage_id"].ToString() != "") { model.dkmassage_id = int.Parse(row["dkmassage_id"].ToString()); } if (row["user_id"] != null && row["user_id"].ToString() != "") { model.user_id = int.Parse(row["user_id"].ToString()); } if (row["acc_type"] != null && row["acc_type"].ToString() != "") { model.acc_type = int.Parse(row["acc_type"].ToString()); } } return(model); }
/// <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 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); } }