public JsonResult Delete(string id)
{
SysMenu.Delete("where id in (@0)", id.ToIntList());
SysFunction.Delete("where menu_id in (@0)", id.ToIntList());
return(Json(ArtDialogResponseResult.SuccessResult));
}
public ActionResult GatePass()
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
string DealerCode = Session["DealerCode"].ToString();
string old = grl.GetStringValuesAgainstCodes("TransCode", Session["TransCode"].ToString(), "GatePassCode", "GatePassTemp", " and Module='Sales'", Session["DealerCode"].ToString());
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@DONo", SqlDbType.VarChar)
};
param[0].Value = DealerCode;
param[1].Value = old;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
if (sysFunc.ExecuteSP("SP_DeliveryOrderGatePass", param, ref rder))
{
data.SP_DeliveryOrderGatePass.Load(rder);
}
RD.Load(Server.MapPath("~/Reports/rptGatePass.rpt"));
//RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Delivery Order Gate Pass'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "ProductReceiptReport.pdf"));
}
catch
{
throw;
}
}
/// <summary>
/// 更新SysFunction信息
/// </summary>
public static void UpdateSysFunction(SysFunction entity)
{
DataCommand cmd = new DataCommand("UpdateSysFunction");
cmd.SetParameter <SysFunction>(entity);
cmd.ExecuteNonQuery();
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(SysFunction e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateSysFunction = cmdUpdateSysFunction.Clone() as MySqlCommand;
_cmdUpdateSysFunction.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateSysFunction.Parameters["@IdsysFunction"].Value = e.IdsysFunction;
_cmdUpdateSysFunction.Parameters["@FunctionName"].Value = e.FunctionName;
_cmdUpdateSysFunction.Parameters["@FatherId"].Value = e.FatherId;
_cmdUpdateSysFunction.Parameters["@Mark"].Value = e.Mark;
_cmdUpdateSysFunction.Parameters["@FunctionUrl"].Value = e.FunctionUrl;
_cmdUpdateSysFunction.Parameters["@FunctionCode"].Value = e.FunctionCode;
_cmdUpdateSysFunction.Parameters["@Level"].Value = e.Level;
_cmdUpdateSysFunction.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateSysFunction.Dispose();
_cmdUpdateSysFunction = null;
GC.Collect();
}
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Insert(SysFunction e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertSysFunction = cmdInsertSysFunction.Clone() as MySqlCommand;
bool returnValue = false;
_cmdInsertSysFunction.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertSysFunction.Parameters["@IdsysFunction"].Value = e.IdsysFunction;
_cmdInsertSysFunction.Parameters["@FunctionName"].Value = e.FunctionName;
_cmdInsertSysFunction.Parameters["@FatherId"].Value = e.FatherId;
_cmdInsertSysFunction.Parameters["@Mark"].Value = e.Mark;
_cmdInsertSysFunction.Parameters["@FunctionUrl"].Value = e.FunctionUrl;
_cmdInsertSysFunction.Parameters["@FunctionCode"].Value = e.FunctionCode;
_cmdInsertSysFunction.Parameters["@Level"].Value = e.Level;
_cmdInsertSysFunction.ExecuteNonQuery();
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertSysFunction.Dispose();
_cmdInsertSysFunction = null;
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
SysFunction sysFunc = new SysFunction();
Data.DSReports data = new Data.DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@TicketNo", SqlDbType.Char), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtTicketNo.Text;
SqlDataReader rder = null;
// Store Procedure check and load
if (sysFunc.ExecuteSP("SP_Report_Complaint", param, ref rder)) //Database SP
{
data.EnforceConstraints = false;
data.SP_Report_Complaint.Load(rder); // DataSet SP
}
// Load in crystal report
//RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt"));
RD.Load(Server.MapPath("/Reports/rptComplaint.rpt"));
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAdress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
// RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Complain'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
// RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
// RD.DataDefinition.FormulaFields["ComplaintTypeCode"] = "'"+txtTicketNo.Text+"'";
// mention paper size
//RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~/Download/");
string FileName = "CounterSalesDetail" + Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
string File = FilePath + FileName;
Session["RD"] = RD;
string URL;
URL = "../../../Download/rptViewerService.aspx?FileName=" + FileName;
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
/// <summary>
/// 获取指定记录
/// <param name="id">Id值</param>
/// </summary>
public SysFunction Get(int IdsysFunction)
{
SysFunction returnValue = null;
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdGetSysFunction = cmdGetSysFunction.Clone() as MySqlCommand;
_cmdGetSysFunction.Connection = oc;
try
{
_cmdGetSysFunction.Parameters["@IdsysFunction"].Value = IdsysFunction;
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
MySqlDataReader reader = _cmdGetSysFunction.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
returnValue = new SysFunction().BuildSampleEntity(reader);
}
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdGetSysFunction.Dispose();
_cmdGetSysFunction = null;
GC.Collect();
}
return(returnValue);
}
public FrmFunctionEdit(DBOperateType type, SysFunction function, string parentCode)
{
InitializeComponent();
Type = type;
Function = function;
ParentCode = parentCode;
}
private ArrayList GetAuthorFunctionList(UltraTree tree)
{
ArrayList funList = new ArrayList();
short level = 0;
IList <IEnumerator> nodeList = new List <IEnumerator>();
nodeList.Add(tree.Nodes.GetEnumerator());
while (level >= 0)
{
IEnumerator enumer = nodeList[level];
if (enumer.MoveNext())
{
UltraTreeNode node = (UltraTreeNode)enumer.Current;
SysFunction fun = new SysFunction();
fun.FunctionId = node.Key;
fun.FunctionName = node.Text;
fun.ParentId = node.Parent != null ? node.Parent.Key : null;
fun.Seq = (short)(node.Index + 1);
funList.Add(fun);
if (node.Nodes.Count > 0)
{
level++;
nodeList.Add(node.Nodes.GetEnumerator());
}
}
else
{
nodeList.RemoveAt(level);
level--;
}
}
return(funList);
}
/// <summary>
/// 从e.Context中获得属性值，并赋值给实体对象
/// </summary>
/// <param name="item"></param>
/// <param name="data"></param>
private void CopyValueFromCallBackData(SysFunction item, Dictionary <string, object> data)
{
if (item != null)
{
item.Permission_Name = Convert.ToString(data["PermissionName"]);
if (!string.IsNullOrEmpty(Convert.ToString(data["SecondPermissionType"])))
{
item.Permission_Type = Convert.ToString(data["SecondPermissionType"]).ToLongNullable();
}
else
{
item.Permission_Type = Convert.ToString(data["PermissionType"]).ToLongNullable();
}
item.Function_Comment = Convert.ToString(data["FunctionComment"]);
item.URL = Convert.ToString(data["URL"]);
item.Is_Menu = Convert.ToBoolean(data["IsMenu"]).ToInt();
item.Entity_ID = Convert.ToString(data["EntityId"]).ToLongNullable();
item.PageId = Convert.ToString(data["PageId"]).ToLongNullable();
item.OrderIndex = Convert.ToString(data["OrderIndex"]).ToIntNullable();
item.Category = Convert.ToString(data["Category"]);
item.ClassName = Convert.ToString(data["ClassName"]);
}
}
/// <summary>
/// 计算URL
/// </summary>
/// <param name="entityId"></param>
/// <param name="pageId"></param>
/// <returns></returns>
public string GetPageUrl(SysFunction p)
{
var entityId = p.Entity_ID;
var pageId = p.PageId;
string result = string.Empty;
if (!string.IsNullOrEmpty(p.URL)) //以自定义的为准
{
result = p.URL;
}
else //否则根据实体和页面来
{
if (entityId != null && pageId != null)
{
var entity = this.EntityCache.FindById <SysEntity>(entityId);
var page = this.EntityCache.FindById <SysPage>(pageId);
result = GetPageUrl(entity, page);
}
}
if (result.IsNullOrEmpty())
{
return(result);
}
return(AddModuleAndFunctionId(p, this.ResolveUrl(result)));
}
protected void ddlBays_SelectedIndexChanged(object sender, EventArgs e)
{
String sql = "select BayID,BayDesc,ShopID,Active from Bay where DealerCode = '" + Session["DealerCode"].ToString() + "' and BayID = '" + ddlBays.SelectedValue + "'";
SysFunction sysFunc = new SysFunction();
dt = sysFunc.GetData(sql);
if (dt.Rows.Count > 0)
{
txtBayId.Text = dt.Rows[0]["BayID"].ToString();
txtBayDesc.Text = dt.Rows[0]["BayDesc"].ToString();
ddlShop.SelectedValue = dt.Rows[0]["ShopID"].ToString();
if (dt.Rows[0]["Active"].ToString() == "Y")
{
chkActive.Checked = true;
}
else
{
chkActive.Checked = false;
}
}
else
{
lblMsg.Text = "No Data Found!";
}
}
/// <summary>
/// 根据编号删除方法
/// </summary>
/// <param name="code">需要删除的方法编号</param>
public bool DeleteByCode(string functionCode)
{
bool res = true;
try
{
Repository<SysFunction> sysFunctionEditModelDal = _unitOfWork.GetRepository<SysFunction>();
SysFunction sysFunctionEiditModel = sysFunctionEditModelDal.GetObjectByKey(functionCode).Entity;
if (sysFunctionEditModelDal != null)
{
_unitOfWork.AddAction(sysFunctionEiditModel, DataActions.Delete);
_unitOfWork.Save();
}
else
{
res = false;
throw new FaultException<LCFault>(new LCFault("编号删除失败"), "该编号不存在，无法删除");
}
}
catch (RepositoryException rex)
{
string msg = rex.Message;
string reason = rex.StackTrace;
throw new FaultException<LCFault>
(new LCFault(msg), reason);
}
catch (Exception ex)
{
string msg = ex.Message;
string reason = ex.StackTrace;
throw new FaultException<LCFault>
(new LCFault(msg), reason);
}
return res;
}
public static List <DealerInfoVM> LoginRequest(string user, string pass, ref string msg)
{
SysFunction myFunc = new SysFunction();
string json = "";
var Serializer = new JavaScriptSerializer();
List <DealerInfoVM> lst = new List <DealerInfoVM>();
try
{
DataTable dt = myFunc.GetDatas("select A.DealerCode,A.UserID ,A.UserName,A.ID,B.DealerDesc,B.Address1 ,B.Address2,B.Address3,B.Email,B.Fax,B.Phone1 ,B.NTN,B.Phone2,B.SaleTaxNo,B.Image,B.Logo,C.EmpCode,C.EmpName from SecurityUser A inner join DealerEmp C On A.DealerCode = C.DealerCode and C.EmpCode = A.EmpCode inner join Dealer B On A.DealerCode=B.DealerCode where A.UserName = '******' and A.Password='******' And A.Active='Y'", "BMS0517ConnectionString", ref msg);
if (dt == null)
{
msg = msg + " Invalid Connection Please Contact to Administrator";
return(lst);
}
if (dt.Rows.Count > 0)
{
lst = EnumerableExtension.ToList <DealerInfoVM>(dt);
json = Serializer.Serialize(lst);
}
}
catch (Exception ex)
{
throw;
}
return(lst);
}
/// <summary>
/// 根据编号查找方法编辑对象
/// </summary>
/// <param name="code">方法编号</param>
public FunctionEditModel GetFunctionByCode(string functionCode)
{
try
{
FunctionEditModel roleEditModel = new FunctionEditModel();
Repository<SysFunction> sysFunctionDal = _unitOfWork.GetRepository<SysFunction>();
SysFunction sysFunction = sysFunctionDal.GetObjectByKey(functionCode).Entity;
if (sysFunction != null)
{
roleEditModel.InitEditModel(sysFunction);
}
return roleEditModel;
}
catch (RepositoryException rex)
{
string msg = rex.Message;
string reason = rex.StackTrace;
throw new FaultException<LCFault>
(new LCFault(msg), reason);
}
catch (Exception ex)
{
string msg = ex.Message;
string reason = ex.StackTrace;
throw new FaultException<LCFault>
(new LCFault(msg), reason);
}
}
private string GetPageUrl(SysFunction p)
{
if (p.Permission_Type == null || p.Permission_Type == 0)
{
return(null);
}
return((this.Master as Site).GetPageUrl(p));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SysFunction sf = new SysFunction();
//bindcate(sf.get_groups());
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
Data.DSReports data = new Data.DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@PPRCOde", SqlDbType.Char), //1
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlPRNo.SelectedValue;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
if (sysFunc.ExecuteSP("SP_PPR_Report", param, ref rder))
{
data.SP_PPR_Report.Load(rder);
}
RD.Load(Server.MapPath("~\\Modules\\Service\\ServiceReports\\TRReport.rpt"));
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Warranty Report'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
// convert and show
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "TRReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
string File = FilePath + FileName;
Session["RD"] = RD;
//RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
string URL;
URL = "../../../Download/rptViewerService.aspx?FileName=" + FileName;
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
public string PushMsg(string strJson)
{
string result = string.Empty;
string message = string.Empty;
try
{
Dictionary <string, string> dic = json.Deserialize <Dictionary <string, string> >(strJson);
BaiduPush Bpush = new BaiduPush("POST");
String messages = "";
String method = "push_msg";
TimeSpan ts = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0));
uint device_type = uint.Parse(dic["deviceType"]);
uint unixTime = (uint)ts.TotalSeconds;
string messageksy = "pushkeys";
string apiKey = SysFunction.GetConfigValue("ApiKey");
if (device_type == 4)
{
IOSNotification notification = new IOSNotification();
notification.title = dic["title"];
notification.description = dic["des"];
messages = notification.getJsonString();
}
else if (device_type == 3)
{
AndroidNotification notification = new AndroidNotification();
notification.title = dic["title"];
notification.description = dic["des"];
messages = notification.getJsonString();
}
PushOptions pOpts;
if (dic["pushType"].Equals("1"))
{
pOpts = new PushOptions(method, apiKey, dic["userID"], dic["channelID"], device_type, messages, messageksy, unixTime);
}
else if (dic["pushType"].Equals("2"))
{
pOpts = new PushOptions(method, apiKey, dic["tag"], device_type, messages, messageksy, unixTime);
}
else
{
pOpts = new PushOptions(method, apiKey, device_type, messages, messageksy, unixTime);
}
pOpts.message_type = uint.Parse(dic["msgType"]);
message = Bpush.PushMessage(pOpts);
result = "0";
}
catch (Exception ex)
{
HandleException(ex, ref result, ref message);
}
return(GetResultStr(result, message));
}
public ActionResult Exports( )
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
string dealerCode = Session["DealerCode"].ToString();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
//new SqlParameter("@BuyingCode",SqlDbType.Char)
};
param[0].Value = dealerCode;
// param[1].Value = EnquiryId;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
try
{
if (sysFunc.ExecuteSP("Select_DealFailYes", param, ref rder))
{
data.EnforceConstraints = false;
data.Select_DealFailYes.Load(rder);
}
RD.Load(Server.MapPath("~/Reports/Sale/DealFailReport.rpt"));
// RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Deal Fail Evaluation Details'";
//RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
// RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
//RD.DataDefinition.FormulaFields["FrontImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic01"].ToString() + "'";
//RD.DataDefinition.FormulaFields["BackImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic02"].ToString() + "'";
//RD.DataDefinition.FormulaFields["LeftImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic03"].ToString() + "'";
//RD.DataDefinition.FormulaFields["RightImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic04"].ToString() + "'";
//RD.DataDefinition.FormulaFields["TopImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic05"].ToString() + "'";
RD.Database.Tables[0].SetDataSource(data);
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "InstallmentReceiptReport.pdf"));
}
catch
{
throw;
}
}
/// <summary>
/// 创建SysFunction信息
/// </summary>
public static int InsertSysFunction(SysFunction entity)
{
DataCommand cmd = new DataCommand("InsertSysFunction");
cmd.SetParameter <SysFunction>(entity);
int result = cmd.ExecuteScalar <int>();
return(result);
}
/// <summary>
/// 获取单个SysFunction信息
/// </summary>
public static SysFunction LoadSysFunction(int sysNo)
{
DataCommand cmd = new DataCommand("LoadSysFunction");
cmd.SetParameter("@SysNo", DbType.Int32, sysNo);
SysFunction result = cmd.ExecuteEntity <SysFunction>();
return(result);
}
private List <SysFunction> GetChilds(SysFunction parent, List <SysFunction> res, BizDataContext context)
{
List <SysFunction> list = context.Where <SysFunction>(p => p.Permission_Type == parent.Function_ID);
list.ForEach(delegate(SysFunction p) {
res.AddRange(this.GetChilds(p, res, context));
});
return(list);
}
public static bool Insert_PaymentTaxDetail(List <PaymentReceiptTaxDetailVM> modelDetail, string DealerCode, ref string msg)
{
// var code = "MCM01";
//SysFunction Sys = new SysFunction();
//SysFunction sys = new SysFunction();
try
{
if (modelDetail != null)
{
foreach (var item in modelDetail)
{
SqlParameter[] PmtRecTaxDetail_param =
{
/*0*/ new SqlParameter("@DealerCode", DealerCode),
/*1*/ new SqlParameter("@ReceiptNo", strAutoCode),
/*2*/ new SqlParameter("@ReceiptHead", item.ReceiptHead),
/*3*/ new SqlParameter("@AccountCode", item.AccountCode),
/*4*/ new SqlParameter("@Amount", SysFunction.CustomCDBL(item.Amount)),
/*5*/ new SqlParameter("@TaxID", item.TaxID),
/*6*/ new SqlParameter("@TaxPerc", SysFunction.CustomCDBL(item.TaxPerc)),
};
if (sysfun.ExecuteSP_NonQuery("sp_W2_PaymentReceipt_TaxDetail_Insert", PmtRecTaxDetail_param, Trans) == true)
{
IsSaved = true;
}
}
ObjTrans.CommittTransaction(ref Trans);
IsSaved = true;
}
else
{
if (Trans.Connection != null)
{
ObjTrans.CommittTransaction(ref Trans);
}
IsSaved = true;
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
msg = ex.Message;
}
// ObjTrans.CommittTransaction(ref Trans);
return(IsSaved);
}
public string AddModuleAndFunctionId(SysFunction p, string url)
{
if (url.IndexOf('?') == -1)
{
url = string.Format("{0}", url, p.Permission_Type, p.Function_ID);
return(url);
}
url = string.Format("{0}", url, p.Permission_Type, p.Function_ID);
return(url);
}
private void FunctionNodeClick(UltraTreeNode node)
{
SysFunction fun = node.Tag as SysFunction;
switch (fun.FunctionType)
{
case "1011":
ultraTabControl1.Tabs[0].Selected = true;
lblSubSystemPos.Text = AppendTreeText(node, NodeTextAppendType.Child);
txtSystemId.Text = fun.FunctionId;
txtSystemKey.Text = fun.Key;
txtSystemName.Text = fun.FunctionName;
txtSystemUrl.Text = fun.Url;
bilSystemIcon.Text = !string.IsNullOrEmpty(fun.Image) ? fun.Image : "";
break;
case "1012":
ultraTabControl1.Tabs[1].Selected = true;
lblSubSystemPos.Text = AppendTreeText(node, NodeTextAppendType.Current);
lblModulePos.Text = AppendTreeText(node, NodeTextAppendType.Child);
txtSubSysId.Text = fun.FunctionId;
txtSubSysKey.Text = fun.Key;
txtSubSysName.Text = fun.FunctionName;
bilSubSysIcon.Text = fun.Image;
break;
case "1013":
ultraTabControl1.Tabs[2].Selected = true;
lblSubSystemPos.Text = AppendTreeText(node, NodeTextAppendType.Parent);
lblModulePos.Text = AppendTreeText(node, NodeTextAppendType.Current);
lblFormPos.Text = AppendTreeText(node, NodeTextAppendType.Child);
txtModuleId.Text = fun.FunctionId;
txtModuleKey.Text = fun.Key;
txtModuleName.Text = fun.FunctionName;
bilModuleIcon.Text = fun.Image;
break;
case "1014":
ultraTabControl1.Tabs[3].Selected = true;
lblModulePos.Text = AppendTreeText(node, NodeTextAppendType.Parent);
lblFormPos.Text = AppendTreeText(node, NodeTextAppendType.Current);
txtFormId.Text = fun.FunctionId;
txtFormCaption.Text = fun.FunctionName;
txtFormCustom.Text = fun.Tag;
txtFormUrl.Text = fun.Url;
uteFormAssembly.Text = fun.Assemblyname;
bilFormIcon.Text = fun.Image;
ucbFormType.Value = fun.FormType;
uceFormHotkey.Checked = fun.UseHotKey;
uceFormToolbar.Checked = fun.ShowToolBar;
BandButtonGrid(fun.FunctionId);
break;
}
}
/// <summary>
/// 标签操作
/// </summary>
/// <param name="userId">用户id</param>
/// <param name="tag">标签名</param>
/// <param name="method">方法名</param>
/// <param name="result"></param>
/// <param name="message"></param>
private void TagOperation(string userId, string tag, string method, ref string result, ref string message)
{
BaiduPush Bpush = new BaiduPush("POST");
TimeSpan ts = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0));
uint unixTime = (uint)ts.TotalSeconds;
string apiKey = SysFunction.GetConfigValue("ApiKey");
TagOptions tOpts = new TagOptions(method, apiKey, userId, tag, unixTime);
message = Bpush.SetTag(tOpts);
result = "0";
}
public ActionResult Authorize(int id)
{
RoleAuthorizeModel model = new RoleAuthorizeModel
{
Role = SysRole.SingleOrDefault(id),
Funcs = SysFunction.Fetch(Sql.Builder),
Trees = MenuTree.Fetch(Sql.Builder),
SelectedFuncIds = SysPower.Fetch("where master_id=@0 and master_type=@1", id, MasterType.Role.ToString()).Select(power => power.FunctionID)
};
return(View(model));
}
/// <summary>
/// 创建SysFunction信息
/// </summary>
public int InsertSysFunction(SysFunction entity)
{
CheckSysFunction(entity, true);
int result = 0;
lock (codeLock)
{
CreateCode(entity);
result = SysFunctionDA.InsertSysFunction(entity);
}
return(result);
}
public List <SysFunction> GetAllChildsAndSelfByParentId(long parentId)
{
List <SysFunction> list = new List <SysFunction>();
SysFunction item = this.context.FindById <SysFunction>(new object[] { parentId });
if (item != null)
{
list.Add(item);
}
list.AddRange(this.GetAllChildsByParentId(parentId));
return(list);
}
public ActionResult Export(string EnquiryId, string DealerCode)
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@CusCode", SqlDbType.VarChar)
};
param[0].Value = DealerCode;
param[1].Value = EnquiryId;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
if (sysFunc.ExecuteSP("SP_InstallmentLedgerReport", param, ref rder))
{
data.SP_InstallmentLedgerReport.Load(rder);
}
RD.Load(Server.MapPath("~/Reports/InstallmentLedgerReport.rpt"));
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'CUSTOMER INSTALLMENT LEDGER'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "ProductReceiptReport.pdf"));
}
catch
{
throw;
}
}
//保存
private void btnSave_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (validationProvider.Validate())
{
if (Type == DBOperateType.Insert)
{
Function = new SysFunction();
Function.ParentCode = ParentCode;
Function.Valid = true;
}
Function.Code = txtCode.Text.Trim();
Function.Name = txtFunctionName.Text.Trim();
Function.ControlType = txtControlType.Text.Trim();
Function.OrderID = Convert.ToInt16(spinEditOrderID.Value);
if (cheQuery.Checked) Function.QueryFlag = true; else Function.QueryFlag = null;
if (cheInsert.Checked) Function.InsertFlag = true; else Function.InsertFlag = null;
if (cheUpdate.Checked) Function.UpdateFlag = true; else Function.UpdateFlag = null;
if (cheDelete.Checked) Function.DeleteFlag = true; else Function.DeleteFlag = null;
if (cheSave.Checked) Function.SaveFlag = true; else Function.SaveFlag = null;
if (chePrint.Checked) Function.PrintFlag = true; else Function.PrintFlag = null;
if (cheImport.Checked) Function.ImportFlag = true; else Function.ImportFlag = null;
if (cheExport.Checked) Function.ExportFlag = true; else Function.ExportFlag = null;
Function.ModifyUser = Identity.CurrentUser.UserName;
Function.ModifyDate = DateTime.Now;
if (Type == DBOperateType.Insert)
WcfServiceHelper.Client.InsertFunction(Function);
else
WcfServiceHelper.Client.UpdateFunction(Function);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
ControlsHelper.ShowErrorMessage("保存失败", ex.Message);
}
finally
{
this.Cursor = Cursors.Default;
}
}
public void Insert(string FpSBranchID,string SFunctionName,string SDLLname,string SFormName,string SAssemblyName,bool? BEnable,string SDesc)
{
SysFunction item = new SysFunction();
item.FpSBranchID = FpSBranchID;
item.SFunctionName = SFunctionName;
item.SDLLname = SDLLname;
item.SFormName = SFormName;
item.SAssemblyName = SAssemblyName;
item.BEnable = BEnable;
item.SDesc = SDesc;
item.Save(UserName);
}
public void Update(long PkIid,string FpSBranchID,string SFunctionName,string SDLLname,string SFormName,string SAssemblyName,bool? BEnable,string SDesc)
{
SysFunction item = new SysFunction();
item.MarkOld();
item.IsLoaded = true;
item.PkIid = PkIid;
item.FpSBranchID = FpSBranchID;
item.SFunctionName = SFunctionName;
item.SDLLname = SDLLname;
item.SFormName = SFormName;
item.SAssemblyName = SAssemblyName;
item.BEnable = BEnable;
item.SDesc = SDesc;
item.Save(UserName);
}
/// <summary>
/// 获取指定记录
/// <param name="id">Id值</param>
/// </summary>
public SysFunction Get(int IdsysFunction)
{
SysFunction returnValue = null;
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdGetSysFunction = cmdGetSysFunction.Clone() as MySqlCommand;
_cmdGetSysFunction.Connection = oc;
try
{
_cmdGetSysFunction.Parameters["@IdsysFunction"].Value = IdsysFunction;
if (oc.State == ConnectionState.Closed)
oc.Open();
MySqlDataReader reader = _cmdGetSysFunction.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
returnValue = new SysFunction().BuildSampleEntity(reader);
}
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdGetSysFunction.Dispose();
_cmdGetSysFunction = null;
GC.Collect();
}
return returnValue;
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(SysFunction e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateSysFunction = cmdUpdateSysFunction.Clone() as MySqlCommand;
_cmdUpdateSysFunction.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
oc.Open();
_cmdUpdateSysFunction.Parameters["@IdsysFunction"].Value = e.IdsysFunction;
_cmdUpdateSysFunction.Parameters["@FunctionName"].Value = e.FunctionName;
_cmdUpdateSysFunction.Parameters["@FatherId"].Value = e.FatherId;
_cmdUpdateSysFunction.Parameters["@Mark"].Value = e.Mark;
_cmdUpdateSysFunction.Parameters["@FunctionUrl"].Value = e.FunctionUrl;
_cmdUpdateSysFunction.Parameters["@FunctionCode"].Value = e.FunctionCode;
_cmdUpdateSysFunction.Parameters["@Level"].Value = e.Level;
_cmdUpdateSysFunction.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateSysFunction.Dispose();
_cmdUpdateSysFunction = null;
GC.Collect();
}
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Insert(SysFunction e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertSysFunction = cmdInsertSysFunction.Clone() as MySqlCommand;
bool returnValue = false;
_cmdInsertSysFunction.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
oc.Open();
_cmdInsertSysFunction.Parameters["@IdsysFunction"].Value = e.IdsysFunction;
_cmdInsertSysFunction.Parameters["@FunctionName"].Value = e.FunctionName;
_cmdInsertSysFunction.Parameters["@FatherId"].Value = e.FatherId;
_cmdInsertSysFunction.Parameters["@Mark"].Value = e.Mark;
_cmdInsertSysFunction.Parameters["@FunctionUrl"].Value = e.FunctionUrl;
_cmdInsertSysFunction.Parameters["@FunctionCode"].Value = e.FunctionCode;
_cmdInsertSysFunction.Parameters["@Level"].Value = e.Level;
_cmdInsertSysFunction.ExecuteNonQuery();
return returnValue;
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertSysFunction.Dispose();
_cmdInsertSysFunction = null;
}
}
