/// <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));
}
}
