/// <summary> /// 用于财务流水 /// </summary> /// <param name="searchtype">搜索类型 1:按userid检索,2:按UserName检索</param> /// <returns></returns> public DataTable SelByType(SType stype, int searchtype = 1, string search = "") { string strwhere = "1=1 "; if (!string.IsNullOrEmpty(search)) { if (searchtype == 1 && DataConvert.CLng(search) > 0) { strwhere += " AND A.UserID=" + Convert.ToInt32(search); search = DataConverter.CLng(search).ToString(); } else { strwhere += " AND UserName LIKE @search"; search = "%" + search + "%"; } } SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@search", "%" + search + "%") }; string tbname = GetTbName(stype); return(DBCenter.JoinQuery("A.*,B.UserName", tbname, "ZL_User", "A.UserID=B.UserID", strwhere, "A.HisTime DESC", sp)); }
public void SetModel(string primaryKey, string formMode, EntryModel model) { model.ApproveTableName = "AssetsMaintain"; model.ApprovePkField = "assetsMaintainId"; if (formMode != "new" && formMode != "new2") { Dictionary <string, object> paras = new Dictionary <string, object>(); paras.Add("assetsMaintainId", primaryKey); string sql = @"select AssetsMaintain.assetsMaintainNo, AssetsMaintain.assetsMaintainName , AssetsMaintainDetail.maintainDate from AssetsMaintain,AssetsMaintainDetail where AssetsMaintain.assetsMaintainId=AssetsMaintainDetail.assetsMaintainId and AssetsMaintain.assetsMaintainId=@assetsMaintainId"; DataTable dtGrid = AppMember.DbHelper.GetDataSet(sql, paras).Tables[0]; DataRow dr = dtGrid.Rows[0]; model.AssetsMaintainId = primaryKey; model.AssetsMaintainNo = DataConvert.ToString(dr["assetsMaintainNo"]); model.AssetsMaintainName = DataConvert.ToString(dr["assetsMaintainName"]); model.MaintainDate = DataConvert.ToDateTime(dr["maintainDate"]); } }
public Asiento GetById(int id) { Asiento objAsiento = null; String sql = "SELECT * FROM TH_Asiento A INNER JOIN TH_Zona Z ON Z.IdZona = A.IdZona INNER JOIN TH_TEATRO T ON T.IdTeatro = Z.IdTeatro WHERE IdAsiento = @codigo "; OleDbParameter codigo = UtilDA.SetParameters("@codigo", OleDbType.Integer, id); using (var dtr = UtilDA.ExecuteReader(cmd, CommandType.Text, sql, cnx, codigo)) { objAsiento = new Asiento(); objAsiento.IdAsiento = DataConvert.ToInt(dtr["IdAsiento"]); objAsiento.Descripcion = DataConvert.ToString(dtr["A.Descripcion"]); objAsiento.Fila = DataConvert.ToString(dtr["Fila"]); objAsiento.FechaCreacion = DataConvert.ToDateTime(dtr["FechaCrea"]); objAsiento.UsuarioCreacion = DataConvert.ToString(dtr["UserCrea"]); objAsiento.FechaModificacion = DataConvert.ToDateTime(dtr["FechaMod"]); objAsiento.UsuarioModificacion = DataConvert.ToString(dtr["UserMod"]); } UtilDA.Close(cnx); return(objAsiento); }
public ActionResult Index() { M_CommonData storeMod = conBll.SelMyStore(mu.UserName); if (storeMod == null) { return(RedirectToAction("StoreApply")); //申请店铺 } else if (storeMod.Status != 99) //等待审核 { return(RedirectToAction("StoreEdit")); } else { DataTable cmdinfo = conBll.GetContent(storeMod.GeneralID); if (cmdinfo.Rows.Count < 1) { function.WriteErrMsg("店铺信息不完整"); return(Content("")); } DataRow dr = cmdinfo.Rows[0]; //DataTable sstDT = sstbll.GetStyleByModel(Convert.ToInt32(dr["StoreModelID"]), 1); //M_StoreStyleTable sst = sstbll.GetStyleByID(Convert.ToInt32(dr["StoreStyleID"])); //ViewBag.sstdp = MVCHelper.ToSelectList(sstDT, "StyleName", "ID", dr["StoreStyleID"].ToString()); ViewBag.dr = dr; //ViewBag.sstimg = sst == null ? "" : function.GetImgUrl(sst.StylePic); ViewBag.modelhtml = fieldBll.InputallHtml(DataConvert.CLng(dr["StoreModelID"]), 0, new ModelConfig() { ValueDT = cmdinfo }); } DataTable styleDt = styleBll.Sel(); styleDt.Columns["ID"].ColumnName = "TemplateID"; styleDt.Columns["Template_Index"].ColumnName = "TemplateUrl"; styleDt.Columns["Thumbnail"].ColumnName = "TemplatePic"; styleDt.Columns["StyleName"].ColumnName = "rname"; ViewBag.styleDt = styleDt; return(View(storeMod)); }
private static Setting.Setting.UserAgentStruct ReadUserAgentNode(XmlNode child) { //初始化一下userAgent Setting.Setting.UserAgentStruct userAgent = new Setting.Setting.UserAgentStruct(); userAgent.Selected = new KeyValuePair <string, string>(); userAgent.UserAgentList = new Dictionary <string, string>(); foreach (XmlNode c in child.ChildNodes) { if (c.Name == "type") { userAgent.IsRandom = DataConvert.StrToBool(c.InnerText); } else if (c.Name == "option") { //判断name属性是否存在 if (c.Attributes["name"] == null) { continue; } string name = c.Attributes["name"].Value; string value = c.InnerText; if (!string.IsNullOrWhiteSpace(name) && !userAgent.UserAgentList.ContainsKey(name)) { userAgent.UserAgentList.Add(name, value); //判断selected属性是否存在 if (c.Attributes["selected"] == null) { continue; } if (DataConvert.StrToBool(c.Attributes["selected"].Value)) { userAgent.Selected = new KeyValuePair <string, string>(name, value); } } } } return(userAgent); }
protected override int AddData(Dictionary <string, object> objs, UserInfo sysUser, string viewTitle) { string sql = @"select * from AssetsSell where 1<>1 "; DataTable dt = AppMember.DbHelper.GetDataSet(sql, dbUpdate.cmd).Tables[0]; dt.TableName = "AssetsSell"; DataRow dr = dt.NewRow(); string assetsSellId = IdGenerator.GetMaxId(dt.TableName); int retApprove = InitFirstApproveTask("AssetsSell", "AssetsSellId", assetsSellId, viewTitle); foreach (KeyValuePair <string, object> kv in objs) { if (kv.Key != "gridData") { dr[kv.Key] = kv.Value; } } if (retApprove != 0) { dr["approveState"] = "O"; } dr["AssetsSellId"] = assetsSellId; Create5Field(dr, sysUser.UserId, viewTitle); dt.Rows.Add(dr); dbUpdate.Update(dt); List <AssetsSell> gridData = JsonHelper.JSONStringToList <AssetsSell>(DataConvert.ToString(objs["gridData"])); foreach (AssetsSell assetsSell in gridData) { AddDetail(assetsSell, assetsSellId, sysUser.UserId, viewTitle); if (retApprove != 0) { UpdateAssetsState(assetsSell.AssetsId, "XI", sysUser.UserId, viewTitle); } } return(1); }
public JsonResult EntryGridData(string formVar, string formMode, string primaryKey) { try { int pageIndex = DataConvert.ToInt32(Request.Params["page"]); int pageRowNum = DataConvert.ToInt32(Request.Params["rows"]); Dictionary <string, object> paras = SetParas(formVar); int cnt = Repository.GetGridCount(paras, formMode); double aa = (double)cnt / pageRowNum; double pageCnt = Math.Ceiling(aa); var rows = DataTable2Object.Data(EntryGridDataTable(formVar, formMode, primaryKey), EntryGridLayout().GridLayouts); var result = new JsonResult(); result.JsonRequestBehavior = JsonRequestBehavior.AllowGet; result.Data = new { page = pageIndex, records = cnt, total = pageCnt, rows = rows }; return(result); } catch (Exception ex) { AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "AssetsDepreciationController.EntryGridData", "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace); return(new JsonResult()); } }
/* * 后台审核通过,更新头像 */ protected void Page_Load(object sender, EventArgs e) { B_Admin.CheckIsLogged(Request.RawUrl); B_User buser = new B_User(); B_Content conBll = new B_Content(); string ids = Request["ids"]; int status = DataConvert.CLng(Request["status"]); switch (status) { case (int)ZLEnum.ConStatus.Audited: if (!string.IsNullOrEmpty(ids)) { //SafeSC.CheckIDSEx(ids); //string fields = "B.*,A.Title"; //DataTable dt = DBCenter.JoinQuery(fields, "ZL_CommonModel", "ZL_C_LSSQ", "A.ItemID=B.ID", "A.GeneralID IN (" + ids + ")"); //foreach (DataRow dr in dt.Rows) //{ // int uid = DataConvert.CLng(dr["yhid"]); // if (uid < 1) { continue; } // string faceUrl = ExHelper.Json_GetFirstImage(DataConvert.CStr(dr["tx"])); // if (string.IsNullOrEmpty(faceUrl)) { faceUrl = "/Images/userface/noface.png"; } // string name = DataConvert.CStr(dr["Title"]); // string zsxm = DataConvert.CStr(dr["zsxm"]); // DBCenter.UpdateSQL("ZL_User", "Salt=@face,HoneyName=@name,[Permissions]=@zsxm", "UserID=" + uid, new List<SqlParameter>() // { new SqlParameter("face", faceUrl), // new SqlParameter("name",name), // new SqlParameter("zsxm",zsxm) // }); // DBCenter.UpdateSQL("ZL_UserBase","UserFace=@face","UserID="+uid,new List<SqlParameter>() {new SqlParameter("face",faceUrl) }); //} } break; //case (int)ZLEnum.ConStatus.UnAudit: // break; } conBll.UpdateStatus(ids, status); Response.Write("1"); Response.Flush(); Response.End(); return; }
public int AddData(Dictionary <string, object> objs, UserInfo sysUser, string viewTitle, string tableName, string pkField, string pkValue, string approveState, bool isInit = false) { Dictionary <string, object> paras = new Dictionary <string, object>(); paras.Add("tableName", tableName); paras.Add("refId", pkValue); paras.Add("approver", sysUser.UserId); string sql = @"select isnull(max(seqno),0) seqno from AppApprove where tableName=@tableName and refId=@refId and approver=@approver "; DataTable dtSeqno = AppMember.DbHelper.GetDataSet(sql, paras, DbUpdate.cmd).Tables[0]; int seqno = DataConvert.ToInt32(dtSeqno.Rows[0]["seqno"]); sql = @"select * from AppApprove where 1<>1 "; DataTable dt = AppMember.DbHelper.GetDataSet(sql, DbUpdate.cmd).Tables[0]; dt.TableName = "AppApprove"; DataRow dr = dt.NewRow(); foreach (KeyValuePair <string, object> kv in objs) { dr[kv.Key] = kv.Value; } if (approveState == "A" && seqno == 0) { dr["seqno"] = seqno + 2; } else { dr["seqno"] = seqno + 1; } //dr["approveId"] = IdGenerator.GetMaxId(dt.TableName); Create5Field(dr, sysUser.UserId, viewTitle); dt.Rows.Add(dr); DbUpdate.Update(dt); if (!isInit) { OverrideRefTable(tableName, pkField, pkValue, sysUser, viewTitle, approveState); } return(1); }
public override void SetText() { checked { if (!string.IsNullOrEmpty(this.Data)) { string data = this.Data; int num = 0; int num2 = DataConvert.HexToInt(data.Substring(num, 2)); num += 2; for (int i = 0; i < num2; i++) { string value = base.OperaRec(data.Substring(num, 4), "A19"); num += 4; string value2 = base.OperaRec(data.Substring(num, 4), "A19"); num += 4; this.DataGridView1.Rows[i].Cells[1].Value = value; this.DataGridView1.Rows[i].Cells[2].Value = value2; } } } }
protected void SetDataRow(EntryModel model, DataRow dr) { dr["assetsClassNo"] = model.AssetsClassNo; dr["assetsClassName"] = model.AssetsClassName; dr["parentId"] = DataConvert.ToString(model.ParentId) == "" ? "0" : DataConvert.ToString(model.ParentId); dr["durableYears"] = DataConvert.ToDBObject(model.DurableYears); dr["remainRate"] = DataConvert.ToDBObject(model.RemainRate); dr["unitId"] = model.UnitId; dr["depreciationType"] = model.DepreciationType; if (DataConvert.ToString(model.ParentId) == "") { dr["assetsClassPath"] = model.AssetsClassId; } else { Dictionary <string, object> paras = new Dictionary <string, object>(); paras.Add("assetsClassId", model.ParentId); string sql = @"select assetsClassPath from AssetsClass where assetsClassId=@assetsClassId"; DataTable dtp = AppMember.DbHelper.GetDataSet(sql, paras).Tables[0]; dr["assetsClassPath"] = DataConvert.ToString(dtp.Rows[0]["assetsClassPath"]) + "," + model.AssetsClassId; } }
public ActionResult Contact() { if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm")) { return(null); } F_CRMS_Contact filter = new F_CRMS_Contact() { ClientID = DataConvert.CLng(Request["Cid"], -100), Name = Request["name"] }; PageSetting setting = contactBll.SelPage(CPage, PSize, filter); if (function.isAjax()) { return(PartialView("Contact_List", setting)); } else { return(View("Contact", setting)); } }
public ActionResult ClientListDiag() { if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm")) { return(null); } int clientId = DataConvert.CLng(Request["Cid"]); PageSetting setting = clientBll.SelPage(CPage, PSize, new F_CRMS_Client() { ctype = Request["ctype"], ignoreCids = clientId.ToString() }); if (function.isAjax()) { return(PartialView("ClientListDiag_List", setting)); } else { return(View(setting)); } }
protected void saveBtn_Click(object sender, EventArgs e) { string st = beginTimeT.Text.Trim(); string et = endTimeT.Text.Trim(); if (string.IsNullOrEmpty(st) || string.IsNullOrEmpty(et)) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('时间不能为空!!!');", true); } else if (!DataConvert.IsDate(st) || !DataConvert.IsDate(et)) { //只有时间也能正常判断,格式则为2014-04-10 17:00:00.000 Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('日期格式不正确!!!');", true); } else if (Convert.ToDateTime(st) >= Convert.ToDateTime(et)) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('起始时间不能大于或等于下次结束时间');", true); } else { //正常处理 bcMod.BCName = bcNameT.Text.Trim(); bcMod.Remind = remindT.Text.Trim(); bcMod.StartTime = Convert.ToDateTime(st); bcMod.EndTime = Convert.ToDateTime(et); bcMod.AddTime = DateTime.Now; bcMod.BackColor = ColorDefault.Text.Trim(); if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { bcMod.ID = DataConverter.CLng(Request.QueryString["ID"]); bcBll.UpdateByID(bcMod); } else { bcBll.Insert(bcMod); } Response.Redirect("BCManage.aspx"); } }
public List <Categoria> List_Categoria_Paginate(PaginateParams paginateParams) { var list = new List <Categoria>(); try { SQLServer.OpenConection(); SQLServer.CreateCommand("up_Categoria_Sellst_Paginate", CommandType.StoredProcedure, SQLServer.CreateParameter("SortDirection", SqlDbType.VarChar, paginateParams.SortDirection), SQLServer.CreateParameter("SortColumn", SqlDbType.VarChar, paginateParams.SortColumn), SQLServer.CreateParameter("PageIndex", SqlDbType.Int, paginateParams.PageIndex), SQLServer.CreateParameter("RowsPerPage", SqlDbType.Int, paginateParams.RowsPerPage), SQLServer.CreateParameter("Paginate", SqlDbType.Bit, paginateParams.IsPaginate), SQLServer.CreateParameter("Filters", SqlDbType.Structured, paginateParams.Filters)); using (var dataReader = SQLServer.GetDataReader(CommandBehavior.CloseConnection)) { while (dataReader.Read()) { var objCategoria = new Categoria(); paginateParams.TotalRows = DataConvert.ToInt(dataReader["List_TotalRegistros"]); objCategoria.IDCategoria = DataConvert.ToInt(dataReader["N_IDCategoria"]); objCategoria.Orden = DataConvert.ToInt(dataReader["N_Orden"]); objCategoria.Descripcion = DataConvert.ToString(dataReader["S_Descripcion"]); objCategoria.Color = DataConvert.ToString(dataReader["S_Color"]); objCategoria.Estado = DataConvert.ToString(dataReader["S_Estado"]).Equals("ACT") ? "Activo" : "Inactivo"; list.Add(objCategoria); } } SQLServer.CloseConection(); } catch (Exception ex) { Log _log = new Log { IDCategoria = 2, UsuarioCreacion = "", Mensaje = "Origen:REPOSITORY - Método:List_Categoria_Paginate(Repository Categoria) - Error:" + ex.GetBaseException().ToString() }; _LogRepository.Insert(_log); } return(list); }
protected override int Add(EntryViewModel model, UserInfo sysUser, string viewTitle) { string sql = @"select * from AssetsLease where 1<>1 "; DataTable dt = AppMember.DbHelper.GetDataSet(sql, DbUpdate.cmd).Tables[0]; dt.TableName = "AssetsLease"; DataRow dr = dt.NewRow(); string assetsLeaseId = IdGenerator.GetMaxId(dt.TableName); int retApprove = InitFirstApproveTask("AssetsLease", "AssetsLeaseId", assetsLeaseId, viewTitle, "", sysUser.UserId); EntryModel myModel = model as EntryModel; dr["assetsLeaseNo"] = myModel.AssetsLeaseNo; dr["assetsLeaseName"] = myModel.AssetsLeaseName; dr["leaseDate"] = DataConvert.ToDBObject(myModel.LeaseDate); string updateType = "Add"; if (retApprove != 0) { dr["approveState"] = "O"; updateType = "ApproveAdd"; } dr["AssetsLeaseId"] = assetsLeaseId; dr["setBooksId"] = sysUser.MySetBooks.SetBooksId; dt.Rows.Add(dr); Create5Field(dt, sysUser.UserId, viewTitle); DbUpdate.Update(dt); List <AssetsLease> gridData = JsonHelper.JSONStringToList <AssetsLease>(DataConvert.ToString(myModel.EntryGridString)); foreach (AssetsLease assetsLease in gridData) { AddDetail(assetsLease, assetsLeaseId, sysUser, viewTitle, updateType); if (retApprove != 0) { UpdateAssetsState(assetsLease.AssetsId, "LI", sysUser.UserId, viewTitle); } } return(1); }
//动态绑定权限列表 private void CreatePermisssionList() { Johnny.CMS.BLL.Access.PermissionCategory category = new Johnny.CMS.BLL.Access.PermissionCategory(); IList <Johnny.CMS.OM.Access.PermissionCategory> categoryModel = category.GetList(); string hdnSeletedClientID = ""; string hdnRightClientID = ""; foreach (Johnny.CMS.OM.Access.PermissionCategory item in categoryModel) { permissioncontrol permissionCtrl = (permissioncontrol)LoadControl("..\\usercontrol\\permissioncontrol.ascx"); permissionCtrl.RoleId = DataConvert.GetInt32(ddlRoles.SelectedValue); permissionCtrl.PermissionCategoryId = item.PermissionCategoryId; permissionCtrl.PermissionCategoryName = item.PermissionCategoryName; PlaceHolder1.Controls.Add(permissionCtrl); HtmlInputHidden hdnValue = (HtmlInputHidden)permissionCtrl.FindControl("hdnSelected"); HtmlSelect hdnRightList = (HtmlSelect)permissionCtrl.FindControl("lstRight"); hdnSeletedClientID = hdnSeletedClientID + hdnValue.ClientID + ","; hdnRightClientID = hdnRightClientID + hdnRightList.ClientID + ","; } btnSave.Attributes.Add("onclick", "return Save('" + ddlRoles.ClientID + "','" + hdnSeletedClientID + "','" + hdnAllSelected.ClientID + "');"); btnReset.Attributes.Add("onclick", "listClear('" + hdnRightClientID + "','" + hdnSeletedClientID + "','" + hdnAllSelected.ClientID + "');return false;"); }
protected int AddDetail(AssetsLease AssetsLease, string AssetsLeaseId, UserInfo sysUser, string viewTitle, string updateType) { string sql = @"select * from AssetsLeaseDetail where 1<>1 "; DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0]; dt.TableName = "AssetsLeaseDetail"; DataRow dr = dt.NewRow(); dr["AssetsLeaseId"] = AssetsLeaseId; dr["assetsId"] = AssetsLease.AssetsId; dr["remark"] = AssetsLease.Remark; dr["leaseCompany"] = AssetsLease.LeaseCompany; dr["leaseAmount"] = AssetsLease.LeaseAmount; dr["setBooksId"] = sysUser.MySetBooks.SetBooksId; dt.Rows.Add(dr); if (DataConvert.ToString(AssetsLease.CreateId) != "") { if (updateType == "Reapply") { dr["approveState"] = "O"; } else { dr["approveState"] = AssetsLease.ApproveState; } dr["createId"] = AssetsLease.CreateId; dr["createTime"] = AssetsLease.CreateTime; Update5Field(dt, sysUser.UserId, viewTitle); } else { if (updateType == "ApproveAdd") { dr["approveState"] = "O"; } Create5Field(dt, sysUser.UserId, viewTitle); } return(DbUpdate.Update(dt)); }
public ActionResult CheckPeriod(string fiscalYearId, string fiscalPeriodId) { try { DataRow dr = Repository.GetModel(); if (dr == null || (DataConvert.ToString(dr["fiscalYearIdNext"]) == fiscalYearId && DataConvert.ToString(dr["fiscalPeriodIdNext"]) == fiscalPeriodId)) { return(Content("1", "text/html")); } else { string msg = AppMember.AppText["DepreciationPeriod"] + DataConvert.ToString(dr["fiscalYearIdNextName"]) + "-" + DataConvert.ToString(dr["fiscalPeriodIdNextName"]); return(Content(msg, "text/html")); } } catch (Exception ex) { AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "AssetsDepreciationController.CheckPeriod", "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace); return(Content("[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace, "text/html")); } }
/// <summary> /// 发送验证码短信 /// </summary> public static CommonReturn SendVCode(string mobile, string vcode, string tlp) { SMS_Packet packet = new SMS_Packet(); packet.message = tlp; switch (SMSConfig.Instance.DefaultSMS) { case "qcloud": packet.param.Add("0", vcode); packet.tlpId = DataConvert.CLng(tlp); break; default: if (string.IsNullOrEmpty(packet.message)) { return(CommonReturn.Failed("未指定短信模板内容")); } break; } packet.message = packet.message.Replace("{vcode}", vcode); return(Send(new string[] { mobile }, packet)); }
public ActionResult StockList() { M_Store_Info storeMod = storeBll.SelModelByUser(mu.UserID); F_Stock filter = new F_Stock() { NodeID = DataConvert.CLng(Request["NodeID"]), ProID = DataConvert.CLng(Request["ProID"]), StockType = DataConvert.CLng(Request["StockType"]), StoreID = storeMod.ID, ProName = Request["ProName"], AddUser = Request["AddUser"], SDate = Request["SDate"], EDate = Request["EDate"] }; PageSetting setting = stockBll.SelPage(CPage, PSize, filter); if (Request.IsAjaxRequest()) { return(PartialView("StockList_List", setting)); } return(View(setting)); }
protected void Page_Init(object sender, EventArgs e) { WxAPI.AutoSync(Request.Url.AbsoluteUri); int sid = DataConvert.CLng(Request.QueryString["ID"]); if (sid > 1) { Response.Cookies["sid"].Value = sid.ToString(); } else if (Request.Cookies["sid"] != null)//看Cookie中是否有信息 { sid = DataConvert.CLng(Request.Cookies["sid"].Value); } if (sid < 1) { function.WriteErrMsg("未指定店铺ID"); return; } if (!DBCenter.IsExist("ZL_CommonModel", "GeneralID=" + sid + " AND ModelID=24")) { function.WriteErrMsg("指定店铺的信息不存在"); } }
/// <summary> /// 返回符合查询条件的试卷 /// </summary> /// <returns>符合查询条件的试卷</returns> public IList <ExamResult> GetExamResults(int examId, string organizationName, /*int examId,*/ string examineeName, decimal scoreLower, decimal scoreUpper, int statusId, /*int judgeId,*/ int startRowIndex, int pageSize, string orderBy) { IList <ExamResult> examResults = new List <ExamResult>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_EXAM_RESULT_F";//USP_EXAM_RESULT_S DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_exam_id", DbType.Int32, examId); db.AddInParameter(dbCommand, "p_org_name", DbType.String, organizationName); //db.AddInParameter(dbCommand, "p_exam_id", DbType.Int32, examId); db.AddInParameter(dbCommand, "p_examinee_name", DbType.String, examineeName); db.AddInParameter(dbCommand, "p_status_id", DbType.Int32, statusId); //db.AddInParameter(dbCommand, "p_judge_id", DbType.Int32, judgeId); db.AddInParameter(dbCommand, "p_score_lower", DbType.Decimal, scoreLower); db.AddInParameter(dbCommand, "p_score_upper", DbType.Decimal, scoreUpper); db.AddInParameter(dbCommand, "p_start_row_index", DbType.Int32, startRowIndex); db.AddInParameter(dbCommand, "p_page_size", DbType.Int32, pageSize); db.AddInParameter(dbCommand, "p_order_by", DbType.String, GetMappingOrderBy(orderBy)); //db.AddOutParameter(dbCommand, "p_count", DbType.Int32, 4); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { ExamResult er = null; while (dataReader.Read()) { er = CreateModelObject(dataReader); er.WorkNo = DataConvert.ToString(dataReader[GetMappingFieldName("WorkNo")]); er.PostName = DataConvert.ToString(dataReader[GetMappingFieldName("PostName")]); examResults.Add(er); } } //_recordCount = (int)db.GetParameterValue(dbCommand, "p_count"); return(examResults); }
public IActionResult Promo() { string PStr = GetParam("p"); string PUName = GetParam("pu"); int PUserID = DataConvert.CLng(EncryptHelper.DesDecrypt(PStr)); if (PUserID < 1 && string.IsNullOrEmpty(PUName)) { return(WriteErr("无用户信息")); } if (PUserID > 0) { mu = buser.SelReturnModel(PUserID); } else if (!string.IsNullOrEmpty(PUName)) { mu = buser.GetUserByName(PUName); } //if (mu.UserID < 1) { function.WriteErrMsg("推广用户不存在");return; } //if (mu.UserID > 1) { Response.Cookies["UserState2"]["ParentUserID"] = mu.UserID.ToString(); } return(Redirect("/User/Register?ParentUserID=" + mu.UserID)); }
protected void btnAdd_Click(object sender, System.EventArgs e) { //check category name if (!CheckInputEmptyAndLength(txtPermissionName, "E01301", "E01302", false)) { return; } Johnny.CMS.BLL.Access.Permission bll = new Johnny.CMS.BLL.Access.Permission(); Johnny.CMS.OM.Access.Permission model = new Johnny.CMS.OM.Access.Permission(); if (Request.QueryString["action"] == "modify") { //update model.PermissionId = Convert.ToInt32(Request.QueryString["id"]); model.PermissionName = txtPermissionName.Text; model.PermissionCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue); bll.Update(model); SetMessage(GetMessage("C00003")); } else { //insert model.PermissionName = txtPermissionName.Text; model.PermissionCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue); if (bll.Add(model) > 0) { SetMessage(GetMessage("C00001")); ddlCategory.SelectedIndex = 0; txtPermissionName.Text = ""; } else { SetMessage(GetMessage("C00002")); } } }
public Usuario Insert(Usuario item) { var objResult = new Usuario(); try { var oDatabase = DatabaseFactory.CreateDatabase(); var oDbCommand = oDatabase.GetStoredProcCommand("up_Usuario_Ins"); oDatabase.AddInParameter(oDbCommand, "@ApellidoMaterno", DbType.String, item.ApellidoMaterno); oDatabase.AddInParameter(oDbCommand, "@ApellidoPaterno", DbType.String, item.ApellidoPaterno); oDatabase.AddInParameter(oDbCommand, "@CorreoElectronico", DbType.String, item.CorreoElectronico); oDatabase.AddInParameter(oDbCommand, "@DistritoId", DbType.Int32, item.DistritoId); oDatabase.AddInParameter(oDbCommand, "@DNI", DbType.String, item.DNI); oDatabase.AddInParameter(oDbCommand, "@EspecialidadId", DbType.Int32, item.EspecialidadId); oDatabase.AddInParameter(oDbCommand, "@EsTrabajador", DbType.Int32, item.EsTrabajador?1:0); oDatabase.AddInParameter(oDbCommand, "@strFechaNacimiento", DbType.String, item.strFechaNacimiento); oDatabase.AddInParameter(oDbCommand, "@Nombres", DbType.String, item.Nombres); oDatabase.AddInParameter(oDbCommand, "@NumeroContacto1", DbType.String, item.NumeroContacto1); oDatabase.AddInParameter(oDbCommand, "@NumeroContacto2", DbType.String, item.NumeroContacto2); oDatabase.AddInParameter(oDbCommand, "@TieneEstudios", DbType.Int32, item.TieneEstudios?1:0); oDatabase.AddInParameter(oDbCommand, "@Password", DbType.String, item.Password); oDatabase.AddInParameter(oDbCommand, "@Estado", DbType.String, item.Estado); oDatabase.AddInParameter(oDbCommand, "@DeviceToken", DbType.String, item.DeviceToken); oDatabase.AddInParameter(oDbCommand, "@Origen", DbType.String, item.Origen); oDatabase.AddInParameter(oDbCommand, "@UsuarioIDExterno", DbType.String, item.UsuarioIDExterno); objResult.UsuarioId = DataConvert.ToInt32(oDatabase.ExecuteScalar(oDbCommand)); } catch (Exception ex) { Log _log = new Log { IDCategoria = 2, UsuarioCreacion = "", Mensaje = "Origen:REPOSITORY - Método:Insert(Repository Usuario) - Error:" + ex.GetBaseException().ToString() }; _LogRepository.Insert(_log); } return(objResult); }
/// <summary> /// 根据查询条件获取对象集合 /// </summary> /// <param name="top">查询数量(0:查询所有)</param> /// <param name="conditions">查询(排序)项集合</param> /// <returns>查询结果集合</returns> public override List <T> FindByCondition(int top, List <Item> items) { //构造查询条件 List <DbParameter> pars = new List <DbParameter>(); //生成查询语句 string conSql = getConditionSQL(items, pars);//sql条件部分 string sql; if (top > 0) { conSql += " ORDER BY " + primaryKey + " LIMIT 0," + top; } sql = String.Format(selectSQL, "*", tableName, conSql); List <T> list = new List <T>(); list = DataConvert <T> .ToEntities(DBHelper.Query(sql, pars)); return(list); }
public Usuario UsuarioPorCorreoRS(string CorreoElectronico, string Key) { Usuario objUsuario = null; var oDatabase = DatabaseFactory.CreateDatabase(); var oDbCommand = oDatabase.GetStoredProcCommand("up_Usuario_Sel_Usuario_Por_CorreoRS"); oDatabase.AddInParameter(oDbCommand, "@CorreoElectronico", DbType.String, CorreoElectronico); oDatabase.AddInParameter(oDbCommand, "@Key", DbType.String, Key); using (var oReader = oDatabase.ExecuteReader(oDbCommand)) { while (oReader.Read()) { objUsuario = new Usuario { UsuarioId = DataConvert.ToInt32(oReader["N_UsuarioId"]), ApellidoPaterno = DataConvert.ToString(oReader["S_ApellidoPaterno"]), ApellidoMaterno = DataConvert.ToString(oReader["S_ApellidoMaterno"]), CorreoElectronico = DataConvert.ToString(oReader["S_CorreoElectronico"]), DistritoId = DataConvert.ToInt32(oReader["N_DistritoId"]), CategoriaId = DataConvert.ToInt32(oReader["N_CategoriaId"]), ProvinciaId = DataConvert.ToInt32(oReader["N_ProvinciaId"]), DepartamentoId = DataConvert.ToInt32(oReader["N_DepartamentoId"]), DNI = DataConvert.ToString(oReader["S_DNI"]), EspecialidadId = DataConvert.ToInt32(oReader["N_EspecialidadId"]), EsTrabajador = DataConvert.ToBool(oReader["N_EsTrabajador"]), FechaNacimiento = DataConvert.ToDateTime(oReader["D_FechaNacimiento"]), Nombres = DataConvert.ToString(oReader["S_Nombres"]), NumeroContacto1 = DataConvert.ToString(oReader["S_NumeroContacto1"]), NumeroContacto2 = DataConvert.ToString(oReader["S_NumeroContacto2"]), TieneEstudios = DataConvert.ToBool(oReader["N_TieneEstudios"]), DeviceToken = DataConvert.ToString(oReader["S_DeviceToken"]), Estado = DataConvert.ToString(oReader["S_Usuario_Estado"]) }; } oReader.Close(); } return(objUsuario); }
private void OnTaskStopClick(object sender, EventArgs e) { try { TaskNode tn = this.SelectedNode as TaskNode; if (tn != null) { //icon tn.ImageIndex = DataConvert.GetInt32(IconType.Task); tn.SelectedImageIndex = DataConvert.GetInt32(IconType.Task); TaskEventArgs te = new TaskEventArgs(); te.Task = tn.Task; OnStopTask(te); _executingTaskIdList.Remove(tn.Task.TaskId); } } catch (Exception ex) { ErrorHandler.ShowMessageBox(CGConstants.MODULE_TASKTREE, ex); } }
/// <summary> /// 测试数据输出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void TestDataOutputbutton_Click(object sender, RoutedEventArgs e) { string sFileStyle = "SIG File(.signaltester) | *.signaltester"; string UIKey = "TestdataOutPutFilePathteBox"; string UIKey1 = "OutPutDatasteBox"; string UIKey3 = "L1raButton"; string UIKey4 = "L2raButton"; string sFilePath = UIdictionary[UIKey].MyString; try { bool bOpenEnable = Outputfile(ref sFilePath, sFileStyle); if (bOpenEnable == true) { BaseFactory factory = new BaseFactory(); factory.BaseParameter = CreateConvertParameter(); TestData TestData = (TestData)factory.CreatDataClass("TestData"); List <List <string> > TestDataList = new List <List <string> >(); if (UIdictionary[UIKey3].Mybool == true) { CreateDataMath <string, List <ConveyorRow> > dataMath = TestData.CreateL1Signal; TestDataList = TestData.CreateList(dataMath); } if (UIdictionary[UIKey4].Mybool == true) { CreateDataMath <string, List <ConveyorRow> > dataMath = TestData.CreateL2Signal; TestDataList = TestData.CreateList(dataMath); } UIdictionary[UIKey].MyString = sFilePath; UIdictionary[UIKey1].MyString = DataConvert.ToString(TestDataList); System.IO.File.WriteAllText(@sFilePath, UIdictionary[UIKey1].MyString, Encoding.UTF8); } } catch (Exception ex) { MessageBox.Show("Build Test data Error: " + ex.Message); } GC.Collect(); }