//添加u8采购入库单
public retmsg Add(RdRecord01 mymodel, List <RdRecords01> mylist, string constr)
{
retmsg ret = new retmsg();
SqlConnection conn = new SqlConnection(constr);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
//AutoID,ID,cCode
retCode retCode = new Bll.CommBll.U8IDCommBll().getCode("rd", mylist.Count(), "24", tran);
//赋默认值
RdRecord01 zbmodel = ZbModelMaker(mymodel, retCode);
List <RdRecords01> zbslist = ZbsListMaker(zbmodel.cCode, mylist, retCode);
//写入主表
new RdRecord01Dal().Add(zbmodel, tran);
//写入子表
RdRecords01Dal dal_zbs = new RdRecords01Dal();
foreach (var i in zbslist)
{
dal_zbs.Add(i, tran);
}
//20190611 处理现存量
string xclflag = new Bll.CommBll.U8Comm().GetU8XclFlag(constr, "cgrk");
if (xclflag != "True")
{
//处理库存，增加
new Bll.U8Bll.CurrentStockCommBll().CurrentStockAdd(mymodel, mylist, tran, constr);
}
//20190611 写未记账表
new Bll.U8Bll.CurrentStockCommBll().IA_ST_UnAccVouchAdd01(mylist, tran);
tran.Commit();
conn.Close();
ret.flag = "ok";
ret.message = retCode.CCODE;
return(ret);
}
catch (Exception ex)
{
tran.Rollback();
conn.Close();
ret.flag = "error";
ret.message = "003:" + ex.Message;
return(ret);
}
}
public retmsg NcBill(PingZhengTemp PingZhengTemp, string path)
{
retmsg ret = new retmsg();
//组建xml
string strxml = GetXml(PingZhengTemp, path);
//请求NC服务器得到结果
string strResult = new NCInterface().sendToNC(strxml, PingZhengTemp.urlzt);
string strRelMsg = strResult.Substring(strResult.IndexOf("<resultdescription>") + 19, strResult.IndexOf("</resultdescription>") - strResult.IndexOf("<resultdescription>") - 19);
strRelMsg = strRelMsg.Replace("\r\n", "");
string strPingZheng = strResult.Substring(strResult.IndexOf("<content>") + 9, strResult.IndexOf("</content>") - strResult.IndexOf("<content>") - 9);
int index = strPingZheng.LastIndexOf('-');
if (index == -1)
{
ret.flag = "error";
ret.message = "处理不成功" + strRelMsg;
}
else
{
//凭证号
string strPingZhengHao = strPingZheng.Substring(index + 1);
ret.flag = "ok";
ret.message = strPingZhengHao;
}
return(ret);
}
//公众号 - shengbanglvye
//string AppID = "wx310c5048bf9e3618";
//string AppSecret = "1ed9554708ce8a29e67c2c1cb30cacdd";
#region 发送消息相关
//发送模版信息--微OA任务提醒
//提醒， 发普通消息和图文消息有限制，即 关注者和账号主题 一段时间没互动，就发不过去了，模版信息无此限制，
//这里选用了 微oa 任务模版，其他模版类似，你可以选用其他模版适用不同场景，用法大同小异
public retmsg SendMsg_mb_woarwtx(my_woa model)
{
//string userId = "ojkrJw7RqLdbJtTf0-p270D8bZQc", string title = "", string description = "", string url2 = ""
//模版编号 OPENTM205196607
retmsg ret = new retmsg();
//wx_token.access_token = "";
var access_token = getAccessToken();
var url = "https://api.weixin.qq.com/cgi-bin/message/template/send?access_token=" + access_token;
var postObj = new
{
touser = model.userId,
//行信科技模板号
template_id = "NYqQ_c5Dcw82tIOW9FvwcXPY8FPLC8QPhBrpX5H-ifI",
//胜邦绿野模版号
//template_id = "uY1JBpBqNoCNGL6N-Cv-nDtmRKgydvTA47w4nri5azE",
url = model.url2,
data = new
{
first = new
{
value = model.title,
color = "#173177"
},
keyword1 = new
{
value = model.rwmc,
color = "#173177"
},
keyword2 = new
{
value = model.xgry,
color = "#173177"
},
remark = new
{
value = model.description + " " + DateTime.Now.ToString("yyyy-MM-dd"),
color = "#173177"
}
}
};
string rel = RequestByPost("post", url, JsonConvert.SerializeObject(postObj));
var objRel = JsonConvert.DeserializeObject <SendMsgReturn>(rel);
if (objRel.errcode == "0")
{
ret.flag = "ok";
return(ret);
}
else
{
//记录错误日志 objRel.errcode objRel.errmsg objRel.msgid
ret.flag = "err";
ret.message = "失败-" + objRel.errcode + objRel.errmsg + objRel.msgid;
return(ret);
}
}
//获取微信公众号关注用户
public JsonResult wxgzhuser()
{
retmsg ret = new retmsg();
//获取微信关注列表 引用webservice
//ret.message = new Bll.toDoWxService.DoNcBill().getWXUser();
return(Json(new { message = ret.message }));
}
public JsonResult wxuser_save(string code, string wxid, string wxnc)
{
retmsg ret = new retmsg();
DataHelper.ExcuteNonQuery(@"update t_user
set wxid = '" + wxid + "',wxmc = '" + wxnc + @"'
where code = '" + code + "'");
ret.flag = "ok";
ret.message = "成功";
return(Json(new { success = ret.flag, message = ret.message }));
}
//添加本地采购入库单
public retmsg Add(MyRdRecord01 mymodel, List <MyRdRecords01> mylist, string constr)
{
retmsg ret = new retmsg();
try
{
//对应赋值
RdRecord01 zbmodel = ZbModelMakerDy(mymodel, mylist);
List <RdRecords01> zbslist = ZbsListMaker(mylist);
ret = new Rd01Bll().Add(zbmodel, zbslist, constr);
return(ret);
}
catch (Exception ex)
{
ret.flag = "error";
ret.message = "002:" + ex.Message;
return(ret);
}
}
//废弃
public List <retmsg> getCount()
{
List <retmsg> list = new List <retmsg>();
string username = new UserComm().getUser().name;
string sql = @"select COUNT(*)t from b_wf_records where usercode = '" + username + "' and currentstep='是' and LEN(guid)<>12";
DataTable dt = DataHelper.GetDataTable(sql);
retmsg model = new retmsg();
model.flag = "待审核订单";
model.message = dt.Rows[0][0].ToString();
list.Add(model);
sql = @"select COUNT(*)t from t_order where zb_jbr = '" + username + "' and status='驳回'";
dt = DataHelper.GetDataTable(sql);
model = new retmsg();
model.flag = "驳回待处理";
model.message = dt.Rows[0][0].ToString();
list.Add(model);
return(list);
}
//检测是不是已经结账
public retmsg CheckGL_mend(string date, string constr)
{
retmsg ret = new retmsg();
string year = date.Substring(0, 4);
int month = int.Parse(date.Substring(5, 2));
try
{
string sql = @" select bflag_st
from GL_mend
where iyear = '" + year + @"'
and iperiod = '" + month + @"'";
DataTable dt = U8DataHelper.GetDataTable(constr, sql);
if (dt.Rows.Count == 0)
{
ret.flag = "error";
return(ret);
}
string bflag_st = dt.Rows[0][0].ToString();
if (bflag_st == "True")
{
ret.flag = "error";
ret.message = year + "年" + month + "月已经结账";
return(ret);
}
ret.flag = "ok";
return(ret);
}
catch (Exception ex)
{
ret.flag = "error";
ret.flag = ex.Message;
return(ret);
}
}
public retmsg ProWare(ApiParams param)
{
retmsg ret = new retmsg();
string constr = "";
//起始日志
t_logs LogsModel = new Bll.CommBll.LogsBll().AddBeginLogs(param, "ProWare");
//获取数据库链接
ret = new Bll.CommBll.AccoutBll().getAccout(param.ip, param.accout);
constr = ret.message;
if (ret.flag == "error")
{
//结尾日志--失败
new Bll.CommBll.LogsBll().AddEndLogs(LogsModel, ret.flag, ret.message);
return(ret);
}
try
{
//翻译参数
//主表
MyRdRecord01 model;
using (System.IO.StringReader sr = new System.IO.StringReader(param.paramMain))
{
model = (MyRdRecord01) new Newtonsoft.Json.JsonSerializer().Deserialize(new JsonTextReader(sr), typeof(MyRdRecord01));
}
//子表
List <MyRdRecords01> list;
using (System.IO.StringReader sr = new System.IO.StringReader(param.paramDetails))
{
list = (List <MyRdRecords01>) new Newtonsoft.Json.JsonSerializer().Deserialize(new JsonTextReader(sr), typeof(List <MyRdRecords01>));
}
//检测参数
ret = new Bll.MyU8Bll.CheckParamData().CheckMyRd01(model, list, constr);
if (ret.flag == "error")
{
//throw new Exception(ret.message);
//结尾日志--失败
new Bll.CommBll.LogsBll().AddEndLogs(LogsModel, ret.flag, ret.message);
return(ret);
}
//检测是不是已经记账
ret = new Bll.CommBll.GL_mend().CheckGL_mend(model.create_date, constr);
if (ret.flag == "error")
{
//结尾日志--失败
new Bll.CommBll.LogsBll().AddEndLogs(LogsModel, ret.flag, ret.message);
return(ret);
}
//翻译字段
list = new Bll.MyU8Bll.TransField().TransFieldMyRd01(list, constr);
model.bredvouch = 0;//蓝单标识
//调用方法 --主表部门字段，子表金额数量等字段待处理
ret = new Bll.MyU8Bll.MyRd01Bll().Add(model, list, constr);
//结尾日志--完成
new Bll.CommBll.LogsBll().AddEndLogs(LogsModel, ret.flag, ret.message);
return(ret);
}
catch (Exception ex)
{
ret.flag = "error";
ret.message = "001:" + ex.Message;
//结尾日志--失败
new Bll.CommBll.LogsBll().AddEndLogs(LogsModel, ret.flag, ret.message);
return(ret);
}
}
//组建数据库连接字符串
public retmsg getAccout(string ip, string accout)
{
retmsg ret = new retmsg();
string str = "";
if (string.IsNullOrEmpty(ip))
{
ret.flag = "error";
ret.message = "无效ip";
return(ret);
}
if (string.IsNullOrEmpty(accout))
{
ret.flag = "error";
ret.message = "无效账套号";
return(ret);
}
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("ip", ip);
var list = new Dal.BaseData.t_serverDal(dic, "ip").ToList();
if (list.Count == 0)
{
ret.flag = "error";
ret.message = "无效ip";
return(ret);
}
//获取数据库账套的年度
DataTable dtyear = DataHelper.GetDataTable(@"select cAcc_Id,iyear
from ufsystem..UA_Account
where cAcc_Id = '" + accout + @"'
order by iYear desc");
if (dtyear.Rows.Count < 1)
{
ret.flag = "error";
ret.message = "系统没有查找到该账套号，请检查";
return(ret);
}
string year = dtyear.Rows[0]["iyear"].ToString();
string uid = list.First().username;
string pwd = list.First().pwd;
string db = "UFDATA_" + accout + "_" + year;
str = "Database=" + db + ";Server=" + ip + ";uid=" + uid + ";pwd=" + pwd + ";";
//检测是不是有获取U8ID的存储过程，没有就创建
string sql = @"select 1 from sys.all_objects where [type]='p' and [name]='ZZp_sp_GetID_VS'";
DataTable dt = U8DataHelper.GetDataTable(str, sql);
if (dt.Rows.Count == 0)
{
CreateProGetID(str, accout);
}
ret.flag = "ok";
ret.message = str;
return(ret);
}
//检测采购入库单参数
public retmsg CheckMyRd01(MyRdRecord01 model, List <MyRdRecords01> list, string constr)
{
retmsg ret = new retmsg();
string sql = "";
DataTable dt = new DataTable();
//主表
if (string.IsNullOrEmpty(model.create_by_name))
{
ret.flag = "error";
ret.message = "创建者名称为空";
return(ret);
}
//子表
foreach (var i in list)
{
if (string.IsNullOrEmpty(i.goods_code))
{
ret.flag = "error";
ret.message = "商品编码为空";
return(ret);
}
else
{
//检测是不是存在存货档案中
sql = @"select * from Inventory where cInvMnemCode = '" + i.goods_code + "'";//cInvMnemCode 助记码
dt = U8DataHelper.GetDataTable(constr, sql);
if (dt.Rows.Count == 0)
{
ret.flag = "error";
ret.message = "存货档案中查询不到" + i.goods_code;
return(ret);
}
}
if (string.IsNullOrEmpty(i.supplier_name))
{
ret.flag = "error";
ret.message = "供应商名称为空";
return(ret);
}
else
{
//检测是不是存在供应商档案中
sql = @"select * from Vendor where cVenName = '" + i.supplier_name + "'";//cVenMnemCode 助记码
dt = U8DataHelper.GetDataTable(constr, sql);
if (dt.Rows.Count == 0)
{
ret.flag = "error";
ret.message = "供应商档案中查询不到" + i.supplier_name;
return(ret);
}
}
if (string.IsNullOrEmpty(i.storage_name))
{
ret.flag = "error";
ret.message = "仓库名称为空";
return(ret);
}
else
{
//检测是不是存在仓库档案中
sql = @"select * from Warehouse where cWhName = '" + i.storage_name + "'";
dt = U8DataHelper.GetDataTable(constr, sql);
if (dt.Rows.Count == 0)
{
ret.flag = "error";
ret.message = "仓库档案中查询不到" + i.storage_name;
return(ret);
}
}
if (string.IsNullOrEmpty(i.dept_name))
{
ret.flag = "error";
ret.message = "部门名称为空";
return(ret);
}
else
{
//检测是不是存在仓库档案中 部门名称要模糊查询,20190525
sql = @"select * from Department where cDepName like '%" + i.dept_name + "%'";
dt = U8DataHelper.GetDataTable(constr, sql);
if (dt.Rows.Count == 0)
{
ret.flag = "error";
ret.message = "部门档案中模糊查询不到" + i.dept_name;
return(ret);
}
}
}
return(ret);
}
