/// <summary>
/// 关联发票更新
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Update(DuiZhang obj)
{
try
{
int count = 0;
string sql = "update jinchen.duizhang_info set invoice_index='{0}',invoice_time='{1}' where id={2}";
sql = string.Format(sql, obj.invoice_index, obj.invoice_time, obj.id);
count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult ChangeInvoice(string[] idList, string invoice_index)
{
for (int i = 0; i < idList.Length; i++)
{
DuiZhang duiZhang = new DuiZhang();
duiZhang.id = Convert.ToInt32(idList[i]);
duiZhang.invoice_index = invoice_index;
duiZhang.invoice_time = DateTime.Now;
int flag = DZM.Update(duiZhang);
if (flag == 0)
{
return(Json("fail"));
}
}
return(Json("success"));
}
/// <summary>
/// 插入
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Insert(DuiZhang obj)
{
try
{
string sql = "insert into jinchen.duizhang_info(sale_id,dz_index,dui_num,dui_price,dui_time,company_name," +
"order_name,unit,deliver_time,company_order_index,dui_all_price,invoice_index) values({0},'{1}',{2},{3},'{4}','{5}','{6}','{7}','{8}','{9}',{10},'{11}')";
sql = string.Format(sql, obj.sale_id, obj.dz_index, obj.dui_num, obj.dui_price, obj.dui_time,
obj.company_name, obj.order_name, obj.unit, obj.deliver_time, obj.company_order_index, obj.dui_all_price, obj.invoice_index);
int count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 单笔查询
/// </summary>
/// <returns></returns>
public DuiZhang SelectById(int id)
{
try
{
DuiZhang obj = new DuiZhang();
string sql = null;
sql = "select a.id,a.dz_index,a.dui_num,a.dui_price,a.dui_time,a.company_name,a.order_name,a.unit,a.dui_all_price,a.deliver_time,a.company_order_index,b.deliver_index " +
"from jinchen.duizhang_info a,jinchen.sale_info b where a.sale_id=b.id and a.id={0} ";
sql = string.Format(sql, id);
obj = PostgreHelper.GetSingleEntity <DuiZhang>(sql);
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 编辑处理Excel导入的批量信息
/// </summary>
/// <returns></returns>
public IActionResult EditHandleList()
{
int check = 0;
string[] allList = Convert.ToString(HttpContext.Request.Form["AllList"]).Split(',');
int rowLength = Convert.ToInt32(HttpContext.Request.Form["num"]) - 1;
int all = 0;
for (int i = 0; i < rowLength; i++)
{
string[] res = new string[11];
Array.Copy(allList, i * 11, res, 0, 11);
if (res[1] != "")
{
DuiZhang duiZhang = new DuiZhang();
duiZhang.deliver_time = Convert.ToDateTime(res[1]);
duiZhang.deliver_index = res[2];
duiZhang.company_name = res[3];
duiZhang.order_index = res[4];
duiZhang.order_name = res[5] + res[6];
duiZhang.unit = res[7];
duiZhang.dui_num = Convert.ToDouble(res[8]);
duiZhang.dui_price = Convert.ToDouble(res[9]);
duiZhang.dui_all_price = Convert.ToDouble(res[10]);
duiZhang.invoice_index = " ";
int count = DZM.Insert(duiZhang);
if (count > 0)
{
check++;
}
all++;
}
}
string result = "共" + all + "笔数据，导入成功" + check + "笔数据";
return(Json(result));
}
/// <summary>
/// 插入更新页面
/// </summary>
/// <returns></returns>
public IActionResult PutInvoice()
{
try
{
int count = 0;
bool flag = true;
string[] dzId = Convert.ToString(HttpContext.Request.Form["DZ_Id"]).Split(',');
string invoice_index = Convert.ToString(HttpContext.Request.Form["invoice_index"]);
DuiZhang dz = new DuiZhang();
if (dzId.Length <= 1 && dzId[0] == "")
{
return(Json("Fail"));
}
for (int i = 0; i < dzId.Length; i++)
{
dz.id = Convert.ToInt32(dzId[i]);
dz.invoice_index = invoice_index;
dz.invoice_time = DateTime.Now.ToLocalTime();
count = DZM.Update(dz);
if (count < 1)
{
flag = false;
}
}
if (flag)
{
return(Json("Success"));
}
else
{
return(Json("Fail"));
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 插入更新页面
/// </summary>
/// <returns></returns>
public IActionResult DuiZhang()
{
try
{
int count = 0;
bool flag = true;
string[] saleid = Convert.ToString(HttpContext.Request.Form["Sale_Id"]).Split(',');
string[] duinum = Convert.ToString(HttpContext.Request.Form["Dui_Num"]).Split(',');
string[] duiprice = Convert.ToString(HttpContext.Request.Form["Dui_Price"]).Split(',');
string dz_index = Convert.ToString(HttpContext.Request.Form["dz_index"]);
DuiZhang dz = new DuiZhang();
if (saleid.Length <= 1 && saleid[0] == "")
{
return(Json("Fail"));
}
for (int i = 0; i < saleid.Length; i++)
{
dz.sale_id = Convert.ToInt32(saleid[i]);
Sale sale = SM.SelectById(Convert.ToInt32(saleid[i]));
dz.company_order_index = sale.company_order_index;
dz.company_name = sale.deliver_company_head;
dz.order_name = sale.order_name;
dz.unit = sale.unit;
dz.dui_num = Convert.ToDouble(duinum[i]);
dz.dui_price = sale.deliver_price;
dz.dui_all_price = Convert.ToDouble(duiprice[i]);
dz.deliver_time = sale.insert_time;
dz.dz_index = dz_index;
dz.dui_time = DateTime.Now.ToLocalTime();
count = DZM.Insert(dz);
if (count < 1)
{
flag = false;
}
else
{
double dz_num = sale.dz_num + Convert.ToDouble(duinum[i]);
int id = Convert.ToInt32(saleid[i]);
int updateRes = SM.UpdateDZNum(dz_num, id);
if (updateRes < 1)
{
flag = false;
}
}
}
if (flag)
{
return(Json("Success"));
}
else
{
return(Json("Fail"));
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Update(DuiZhang duiZhang)
{
int count = DZS.Update(duiZhang);
return(count);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Insert(DuiZhang obj)
{
int count = DZS.Insert(obj);
return(count);
}
public DuiZhang SelectById(int id)
{
DuiZhang duiZhang = DZS.SelectById(id);
return(duiZhang);
}
