/// <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)); } }
//获得客户的某一年的起初应收 public string GetFirstReceivable(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select sum(period_start) as period_startSum FROM fms_ac_period "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = FMS_DbHelperMySQL.GetSingle(strSql.ToString()); if (obj == null) { return("0"); } else { return(obj.ToString()); } }
//获得客户的应收款 public string GetCollectedAmoun(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select sum(daifang) as collected_amount from fms_kuan "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = FMS_DbHelperMySQL.GetSingle(strSql.ToString()); if (obj == null) { return("0"); } else { return(obj.ToString()); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(FMS_Model.fms_costitem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into fms_costitem("); strSql.Append("id,Factory_Id,code,title,creater,createtime,item_order,parent_code)"); strSql.Append(" values ("); strSql.Append("@id,@Factory_Id,@code,@title,@creater,@createtime,@item_order,@parent_code)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 11), new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@code", MySqlDbType.VarChar, 255), new MySqlParameter("@title", MySqlDbType.VarChar, 255), new MySqlParameter("@creater", MySqlDbType.VarChar, 255), new MySqlParameter("@createtime", MySqlDbType.DateTime), new MySqlParameter("@item_order", MySqlDbType.Int32, 11), new MySqlParameter("@parent_code", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.id; parameters[1].Value = model.Factory_Id; parameters[2].Value = model.code; parameters[3].Value = model.title; parameters[4].Value = model.creater; parameters[5].Value = model.createtime; parameters[6].Value = model.item_order; parameters[7].Value = model.parent_code; object obj = FMS_DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
//获得客户的调账金额 public string GetTransferAmoun(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select sum(change_total) as transfer_amount from fms_kuan_adjust "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = FMS_DbHelperMySQL.GetSingle(strSql.ToString()); if (obj == null) { return("0"); } else { return(obj.ToString()); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(FMS_Model.fms_kuan_adjust model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into fms_kuan_adjust("); strSql.Append("id,date_time,customer_id,user_id,change_total,change_type,change_desc,admin_id,erp_dakuanhao,erp_time,debit_account_code,credit_account_code,status,approvalPrimary_empId,approvalPrimary_empcode,approvalPrimary_empname,approvalPrimary_Opinion,approvalPrimary_date,approvalOne_empId,approvalOne_empcode,approvalOne_empname,approvalOne_Opinion,approvalOne_date,approvalTwo_empId,approvalTwo_empcode,approvalTwo_date,approvalTwo_status,adjust_sn)"); strSql.Append(" values ("); strSql.Append("@id,@date_time,@customer_id,@user_id,@change_total,@change_type,@change_desc,@admin_id,@erp_dakuanhao,@erp_time,@debit_account_code,@credit_account_code,@status,@approvalPrimary_empId,@approvalPrimary_empcode,@approvalPrimary_empname,@approvalPrimary_Opinion,@approvalPrimary_date,@approvalOne_empId,@approvalOne_empcode,@approvalOne_empname,@approvalOne_Opinion,@approvalOne_date,@approvalTwo_empId,@approvalTwo_empcode,@approvalTwo_date,@approvalTwo_status,@adjust_sn)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 11), 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("@debit_account_code", MySqlDbType.VarChar, 100), new MySqlParameter("@credit_account_code", MySqlDbType.VarChar, 100), new MySqlParameter("@status", MySqlDbType.Int16, 2), new MySqlParameter("@approvalPrimary_empId", MySqlDbType.Int32, 11), new MySqlParameter("@approvalPrimary_empcode", MySqlDbType.VarChar, 60), new MySqlParameter("@approvalPrimary_empname", MySqlDbType.VarChar, 60), new MySqlParameter("@approvalPrimary_Opinion", MySqlDbType.VarChar, 200), new MySqlParameter("@approvalPrimary_date", MySqlDbType.DateTime), new MySqlParameter("@approvalOne_empId", MySqlDbType.Int32, 11), new MySqlParameter("@approvalOne_empcode", MySqlDbType.VarChar, 60), new MySqlParameter("@approvalOne_empname", MySqlDbType.VarChar, 60), new MySqlParameter("@approvalOne_Opinion", MySqlDbType.VarChar, 200), new MySqlParameter("@approvalOne_date", MySqlDbType.DateTime), new MySqlParameter("@approvalTwo_empId", MySqlDbType.Int32, 11), new MySqlParameter("@approvalTwo_empcode", MySqlDbType.VarChar, 60), new MySqlParameter("@approvalTwo_date", MySqlDbType.DateTime), new MySqlParameter("@approvalTwo_status", MySqlDbType.Int16, 2), new MySqlParameter("@adjust_sn", MySqlDbType.VarChar, 20) }; parameters[0].Value = model.id; parameters[1].Value = model.date_time; parameters[2].Value = model.customer_id; parameters[3].Value = model.user_id; parameters[4].Value = model.change_total; parameters[5].Value = model.change_type; parameters[6].Value = model.change_desc; parameters[7].Value = model.admin_id; parameters[8].Value = model.erp_dakuanhao; parameters[9].Value = model.erp_time; parameters[10].Value = model.debit_account_code; parameters[11].Value = model.credit_account_code; parameters[12].Value = model.status; parameters[13].Value = model.approvalPrimary_empId; parameters[14].Value = model.approvalPrimary_empcode; parameters[15].Value = model.approvalPrimary_empname; parameters[16].Value = model.approvalPrimary_Opinion; parameters[17].Value = model.approvalPrimary_date; parameters[18].Value = model.approvalOne_empId; parameters[19].Value = model.approvalOne_empcode; parameters[20].Value = model.approvalOne_empname; parameters[21].Value = model.approvalOne_Opinion; parameters[22].Value = model.approvalOne_date; parameters[23].Value = model.approvalTwo_empId; parameters[24].Value = model.approvalTwo_empcode; parameters[25].Value = model.approvalTwo_date; parameters[26].Value = model.approvalTwo_status; parameters[27].Value = model.adjust_sn; object obj = FMS_DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <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)); } }