public virtual bool AddContractTemplate(ContractTemplateInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Contract_Template";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Contract_Template_ID"] = entity.Contract_Template_ID;
DrAdd["Contract_Template_Name"] = entity.Contract_Template_Name;
DrAdd["Contract_Template_Code"] = entity.Contract_Template_Code;
DrAdd["Contract_Template_Content"] = entity.Contract_Template_Content;
DrAdd["Contract_Template_Addtime"] = entity.Contract_Template_Addtime;
DrAdd["Contract_Template_Site"] = entity.Contract_Template_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual bool EditContractTemplate(ContractTemplateInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "54d1aadd-ca23-4c1a-b56e-793543423a39"))
{
return(MyDAL.EditContractTemplate(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：54d1aadd-ca23-4c1a-b56e-793543423a39错误");
}
}
public virtual bool AddContractTemplate(ContractTemplateInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "09c3558e-e719-4f31-b3ba-c6cabae4fbc9"))
{
return(MyDAL.AddContractTemplate(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：09c3558e-e719-4f31-b3ba-c6cabae4fbc9错误");
}
}
public virtual IList <ContractTemplateInfo> GetContractTemplates(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <ContractTemplateInfo> entitys = null;
ContractTemplateInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Contract_Template";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <ContractTemplateInfo>();
while (RdrList.Read())
{
entity = new ContractTemplateInfo();
entity.Contract_Template_ID = Tools.NullInt(RdrList["Contract_Template_ID"]);
entity.Contract_Template_Name = Tools.NullStr(RdrList["Contract_Template_Name"]);
entity.Contract_Template_Code = Tools.NullStr(RdrList["Contract_Template_Code"]);
entity.Contract_Template_Content = Tools.NullStr(RdrList["Contract_Template_Content"]);
entity.Contract_Template_Addtime = Tools.NullDate(RdrList["Contract_Template_Addtime"]);
entity.Contract_Template_Site = Tools.NullStr(RdrList["Contract_Template_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
//根据编号获取合同当前状态
public ContractTemplateInfo GetContractTemplateState(int ContractTemplate_ID)
{
QueryInfo Query = new QueryInfo();
//Query.CurrentPage = 1;
//Query.PageSize = 0;
//Query.ParamInfos.Add(new ParamInfo("AND", "int", "ContractInfo.Contract_ID", "=", ContractTemplate_ID.ToString()));
ContractTemplateInfo list = MyContractTemplate.GetContractTemplateByID(ContractTemplate_ID, pub.CreateUserPrivilege("d4d58107-0e58-485f-af9e-3b38c7ff9672"));
if (list != null)
{
return(list);
}
else
{
return(null);
}
}
public virtual bool EditContractTemplate(ContractTemplateInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM Contract_Template WHERE Contract_Template_ID = " + entity.Contract_Template_ID;
DtAdd = DBHelper.Query(SqlAdd);
try
{
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Contract_Template_ID"] = entity.Contract_Template_ID;
DrAdd["Contract_Template_Name"] = entity.Contract_Template_Name;
DrAdd["Contract_Template_Code"] = entity.Contract_Template_Code;
DrAdd["Contract_Template_Content"] = entity.Contract_Template_Content;
DrAdd["Contract_Template_Addtime"] = entity.Contract_Template_Addtime;
DrAdd["Contract_Template_Site"] = entity.Contract_Template_Site;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
return(true);
}
public virtual ContractTemplateInfo GetContractTemplateBySign(string Sign)
{
ContractTemplateInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Contract_Template WHERE Contract_Template_Code = '" + Sign + "'";
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new ContractTemplateInfo();
entity.Contract_Template_ID = Tools.NullInt(RdrList["Contract_Template_ID"]);
entity.Contract_Template_Name = Tools.NullStr(RdrList["Contract_Template_Name"]);
entity.Contract_Template_Code = Tools.NullStr(RdrList["Contract_Template_Code"]);
entity.Contract_Template_Content = Tools.NullStr(RdrList["Contract_Template_Content"]);
entity.Contract_Template_Addtime = Tools.NullDate(RdrList["Contract_Template_Addtime"]);
entity.Contract_Template_Site = Tools.NullStr(RdrList["Contract_Template_Site"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
//合同查看打印
public void Contract_View_New(OrdersInfo ordersInfo, int contact_no)
{
string Template_Html = "";
int Contract_ID;
string Time = string.Empty;
string Contract_Product_Goods = "";
string ContractTemplate_TopFuJian = "";
string Sell_Contract_Template_OnlyRead = "";
string Supplier_CompanyName = "";
string Member_NickName = "";
string ContractTemResponsible = string.Empty;
SupplierInfo supplierInfo = null;
SupplierInfo Supplierinfo = null;
string Sell_Contract_Template_EndFuJianContent = "";
Contract_ID = tools.CheckInt(Request["Contract_ID"]);
Contract_Product_Goods = new Contract().Contract_Orders_Goods_Print(Contract_ID);
SupplierInfo MemberSupplierinfo = null;
string MemberSupplierCompanyName = "";
MemberInfo memberInfo = null;
if (ordersInfo != null)
{
memberInfo = new Member().GetMemberByID(ordersInfo.Orders_BuyerID);
Supplierinfo = new Supplier().GetSupplierByID(memberInfo.Member_SupplierID);
if (memberInfo != null)
{
//Member_NickName = memberInfo.Member_NickName;
MemberSupplierinfo = new Supplier().GetSupplierByID(memberInfo.Member_SupplierID);
if (MemberSupplierinfo != null)
{
MemberSupplierCompanyName = MemberSupplierinfo.Supplier_CompanyName;
}
}
}
List <OrdersLogInfo> logs = MyOrdersLog.GetOrdersLogsByOrdersID(ordersInfo.Orders_ID).Where(p => p.Orders_Log_Remark == "供应商确认订单").ToList();
if (ordersInfo != null)
{
supplierInfo = MySupplier.GetSupplierByID(ordersInfo.Orders_SupplierID, pub.CreateUserPrivilege("1392d14a-6746-4167-804a-d04a2f81d226"));
if (supplierInfo != null)
{
Supplier_CompanyName = supplierInfo.Supplier_CompanyName;
}
}
//合同顶部附件
ContractTemplateInfo ContractTemplateEntity = MyContractTemplate.GetContractTemplateBySign("Sell_Contract_Template_TopFuJian", pub.CreateUserPrivilege("d4d58107-0e58-485f-af9e-3b38c7ff9672"));
if (logs.Count > 0)
{
Time = tools.NullStr(logs.FirstOrDefault().Orders_Log_Addtime.ToString("yyyy年MM月dd日"));
}
//合同模板运输责任
ContractTemplateInfo ContractTemResponsibleEntity = MyContractTemplate.GetContractTemplateBySign("Sell_Contract_Template_Responsible", pub.CreateUserPrivilege("d4d58107-0e58-485f-af9e-3b38c7ff9672"));
if (ContractTemResponsibleEntity != null)
{
ContractTemResponsible = ContractTemResponsibleEntity.Contract_Template_Content;
if (ordersInfo != null)
{
ContractTemResponsible = ContractTemResponsible.Replace("{Responsible}", ordersInfo.Orders_Responsible == 1 ? "卖家责任" : "买家责任");
}
}
if (ContractTemplateEntity != null)
{
ContractTemplate_TopFuJian = ContractTemplateEntity.Contract_Template_Content;
ContractTemplate_TopFuJian = ContractTemplate_TopFuJian.Replace("{supplier_name}", Supplier_CompanyName);
ContractTemplate_TopFuJian = ContractTemplate_TopFuJian.Replace("{member_name}", MemberSupplierCompanyName);
ContractTemplate_TopFuJian = ContractTemplate_TopFuJian.Replace("{time}", string.IsNullOrEmpty(Time) ? "卖家尚未确认订单" : Time);
//ContractTemplate_TopFuJian = ContractTemplate_TopFuJian.Replace("{orders_goodslist}", Contract_Product_Goods);
ContractTemplate_TopFuJian = ContractTemplate_TopFuJian.Replace("{orders_goodslist}", new Member().GetOrdersGoods(ordersInfo));
}
//合同尾部附件
ContractTemplateInfo Sell_Contract_Template_EndFuJianEntity = MyContractTemplate.GetContractTemplateBySign("Sell_Contract_Template_EndFuJian", pub.CreateUserPrivilege("d4d58107-0e58-485f-af9e-3b38c7ff9672"));
if (Sell_Contract_Template_EndFuJianEntity != null)
{
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianEntity.Contract_Template_Content;
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianContent.Replace("{member_name}", supplierInfo.Supplier_CompanyName);
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianContent.Replace("{member_adress}", supplierInfo.Supplier_Address);
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianContent.Replace("{member_corproate}", supplierInfo.Supplier_Corporate);
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianContent.Replace("{supplier_name}", Supplierinfo.Supplier_CompanyName);
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianContent.Replace("{supplier_adress}", Supplierinfo.Supplier_Address);
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianContent.Replace("{supplier_corproate}", Supplierinfo.Supplier_Corporate);
}
//易耐网交易合同标准条款
ContractTemplateInfo Sell_Contract_Template_OnlyReadEntity = MyContractTemplate.GetContractTemplateBySign("Sell_Contract_Template_OnlyRead", pub.CreateUserPrivilege("d4d58107-0e58-485f-af9e-3b38c7ff9672"));
if (Sell_Contract_Template_OnlyReadEntity != null)
{
Sell_Contract_Template_OnlyRead = Sell_Contract_Template_OnlyReadEntity.Contract_Template_Content;
}
if (Contract_ID == 0)
{
Response.Write("<script>alert('合同无效!');windwo.close();</script>");
Response.End();
}
ContractInfo entity = GetContractByID(Contract_ID);
if (entity != null)
{
if (Request["action"] == "print")
{
Response.Write("<script>window.print();</script>");
}
string address = "";// /**/
ContractInfo ContractInfo = null;
if (ordersInfo != null)
{
if (MySupplier != null)
{
ContractInfo = MyContract.GetContractByID(contact_no, pub.CreateUserPrivilege("a3465003-08b3-4a31-9103-28d16c57f2c8"));
if (ContractInfo != null)
{
Template_Html = ContractInfo.Contract_Note;
Template_Html = Template_Html.Replace("{supplier_name}", Supplier_CompanyName);
Template_Html = Template_Html.Replace("{member_name}", MemberSupplierCompanyName);
Template_Html = Template_Html.Replace("{orders_address}", addr.DisplayAddress(ordersInfo.Orders_Address_State, ordersInfo.Orders_Address_City, ordersInfo.Orders_Address_County) + ordersInfo.Orders_Address_StreetAddress);
Template_Html = Template_Html.Replace("{supplier_sealimg}", pub.FormatImgURL(supplierInfo.Supplier_SealImg, "fullpath"));
Template_Html = Template_Html.Replace("{orders_paywayname}", ordersInfo.Orders_Payway_Name);
Template_Html = Template_Html.Replace("{orders_deliveryname}", ordersInfo.Orders_Delivery_Name);
Template_Html = Template_Html.Replace("{orders_goodslist}", new Member().GetOrdersGoods(ordersInfo));
if (memberInfo != null)
{
Template_Html = Template_Html.Replace("{member_name}", memberInfo.MemberProfileInfo.Member_Company);
Template_Html = Template_Html.Replace("{member_sealimg}", pub.FormatImgURL(memberInfo.MemberProfileInfo.Member_SealImg, "fullpath"));
}
}
}
Template_Html = ContractTemplate_TopFuJian + Template_Html + ContractTemResponsible + ordersInfo.Orders_ContractAdd + Sell_Contract_Template_OnlyRead + Sell_Contract_Template_EndFuJianContent;;
}
Response.Write(Server.HtmlDecode(Template_Html));
}
else
{
Response.Write("<script>alert('合同无效!');windwo.close();</script>");
Response.End();
}
}
//商家查看打印
public void Contract_View_SupplierNew(OrdersInfo ordersInfo, int contact_no)
{
string Template_Html = "";
int Contract_ID;
string Contract_Product_Goods = "";
string ContractTemplate_TopFuJian = "";
string Sell_Contract_Template_OnlyRead = "";
string Supplier_CompanyName = "";
string Member_NickName = "";
SupplierInfo supplierInfo = null;
string Sell_Contract_Template_EndFuJianContent = "";
MemberInfo memberInfo = new Member().GetMemberByID(ordersInfo.Orders_BuyerID);
Contract_ID = tools.CheckInt(Request["Contract_ID"]);
Contract_Product_Goods = new Contract().Contract_Orders_Goods_Print(Contract_ID);
SupplierInfo MemberSupplierinfo = null;
string MemberSupplierCompanyName = "";
if (memberInfo != null)
{
//Member_NickName = memberInfo.Member_NickName;
MemberSupplierinfo = new Supplier().GetSupplierByID(memberInfo.Member_SupplierID);
if (MemberSupplierinfo != null)
{
MemberSupplierCompanyName = MemberSupplierinfo.Supplier_CompanyName;
}
}
if (ordersInfo != null)
{
supplierInfo = MySupplier.GetSupplierByID(ordersInfo.Orders_SupplierID, pub.CreateUserPrivilege("1392d14a-6746-4167-804a-d04a2f81d226"));
if (supplierInfo != null)
{
Supplier_CompanyName = supplierInfo.Supplier_CompanyName;
}
}
//合同顶部附件
ContractTemplateInfo ContractTemplateEntity = MyContractTemplate.GetContractTemplateBySign("Sell_Contract_Template_TopFuJian", pub.CreateUserPrivilege("d4d58107-0e58-485f-af9e-3b38c7ff9672"));
if (ContractTemplateEntity != null)
{
ContractTemplate_TopFuJian = ContractTemplateEntity.Contract_Template_Content;
ContractTemplate_TopFuJian = ContractTemplate_TopFuJian.Replace("{supplier_name}", Supplier_CompanyName);
ContractTemplate_TopFuJian = ContractTemplate_TopFuJian.Replace("{member_name}", MemberSupplierCompanyName);
ContractTemplate_TopFuJian = ContractTemplate_TopFuJian.Replace("{orders_goodslist}", new Member().GetOrdersGoods(ordersInfo));
}
//合同尾部附件
ContractTemplateInfo Sell_Contract_Template_EndFuJianEntity = MyContractTemplate.GetContractTemplateBySign("Sell_Contract_Template_EndFuJian", pub.CreateUserPrivilege("d4d58107-0e58-485f-af9e-3b38c7ff9672"));
if (Sell_Contract_Template_EndFuJianEntity != null)
{
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianEntity.Contract_Template_Content;
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianContent.Replace("{supplier_name}", Supplier_CompanyName);
Sell_Contract_Template_EndFuJianContent = Sell_Contract_Template_EndFuJianContent.Replace("{member_name}", MemberSupplierCompanyName);
}
//易耐网交易合同标准条款
ContractTemplateInfo Sell_Contract_Template_OnlyReadEntity = MyContractTemplate.GetContractTemplateBySign("Sell_Contract_Template_OnlyRead", pub.CreateUserPrivilege("d4d58107-0e58-485f-af9e-3b38c7ff9672"));
if (Sell_Contract_Template_OnlyReadEntity != null)
{
Sell_Contract_Template_OnlyRead = Sell_Contract_Template_OnlyReadEntity.Contract_Template_Content;
//Sell_Contract_Template_OnlyRead = Sell_Contract_Template_EndFuJianContent.Replace("{supplier_name}", Supplier_CompanyName);
//Sell_Contract_Template_OnlyRead = Sell_Contract_Template_EndFuJianContent.Replace("{member_name}", MemberSupplierCompanyName);
}
if (Contract_ID == 0)
{
Response.Write("<script>alert('合同无效!');windwo.close();</script>");
Response.End();
}
ContractInfo entity = GetContractByID(Contract_ID);
if (entity != null)
{
if (Request["action"] == "print")
{
Response.Write("<script>window.print();</script>");
}
string address = "";// /**/
ContractInfo ContractInfo = null;
//MemberInfo memberInfo = mymember.GetMemberByID();
if (ordersInfo != null)
{
if (MySupplier != null)
{
ContractInfo = MyContract.GetContractByID(contact_no, pub.CreateUserPrivilege("a3465003-08b3-4a31-9103-28d16c57f2c8"));
if (ContractInfo != null)
{
Template_Html = ContractInfo.Contract_Note;
Template_Html = Template_Html.Replace("{supplier_name}", Supplier_CompanyName);
Template_Html = Template_Html.Replace("{member_name}", MemberSupplierCompanyName);
Template_Html = Template_Html.Replace("{orders_address}", addr.DisplayAddress(ordersInfo.Orders_Address_State, ordersInfo.Orders_Address_City, ordersInfo.Orders_Address_County) + ordersInfo.Orders_Address_StreetAddress);
Template_Html = Template_Html.Replace("{supplier_sealimg}", pub.FormatImgURL(supplierInfo.Supplier_SealImg, "fullpath"));
Template_Html = Template_Html.Replace("{orders_paywayname}", ordersInfo.Orders_Payway_Name);
Template_Html = Template_Html.Replace("{orders_deliveryname}", ordersInfo.Orders_Delivery_Name);
Template_Html = Template_Html.Replace("{orders_goodslist}", new Member().GetOrdersGoods(ordersInfo));
if (memberInfo != null)
{
Template_Html = Template_Html.Replace("{member_name}", memberInfo.MemberProfileInfo.Member_Company);
Template_Html = Template_Html.Replace("{member_sealimg}", pub.FormatImgURL(memberInfo.MemberProfileInfo.Member_SealImg, "fullpath"));
}
}
}
Template_Html = ContractTemplate_TopFuJian + Template_Html + ordersInfo.Orders_ContractAdd + Sell_Contract_Template_OnlyRead + Sell_Contract_Template_EndFuJianContent;;
}
Response.Write(Server.HtmlDecode(Template_Html));
}
else
{
Response.Write("<script>alert('合同无效!');windwo.close();</script>");
Response.End();
}
}
