/// <summary> /// 添加备用机 /// </summary> /// <param name="info">备用机信息</param> /// <returns>备用机id</returns> public int AddSpare(InvSpareInfo info) { sqlStr = "INSERT INTO tblInvSpare(FujiClass2ID,SerialCode,Price,StartDate,EndDate,AddDate) " + " VALUES(@FujiClass2ID,@SerialCode,@Price,@StartDate,@EndDate,GetDate()); " + " SELECT @@IDENTITY "; using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr)) { command.Parameters.Add("@FujiClass2ID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.FujiClass2.ID); command.Parameters.Add("@SerialCode", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.SerialCode); command.Parameters.Add("@Price", SqlDbType.Decimal).Value = info.Price; command.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.StartDate); command.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.EndDate); info.ID = SQLUtil.ConvertInt(command.ExecuteScalar()); return(info.ID); } }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MMemberP mod) { SqlCommand cmd = new SqlCommand("STP_MemberPEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberPID", SqlDbType.NVarChar).Value = mod.MemberPID; cmd.Parameters.Add("@MemberPassword", SqlDbType.NVarChar).Value = mod.MemberPassword; cmd.Parameters.Add("@NameC", SqlDbType.NVarChar).Value = mod.NameC; cmd.Parameters.Add("@NameE", SqlDbType.NVarChar).Value = mod.NameE; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = mod.Email; cmd.Parameters.Add("@PID", SqlDbType.NVarChar).Value = mod.PID; cmd.Parameters.Add("@Birthday", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.Birthday); cmd.Parameters.Add("@RegisterDate", SqlDbType.DateTime).Value = mod.RegisterDate; cmd.Parameters.Add("@Sex", SqlDbType.NVarChar).Value = mod.Sex; cmd.Parameters.Add("@Native", SqlDbType.NVarChar).Value = mod.Native; cmd.Parameters.Add("@MemberClass", SqlDbType.NVarChar).Value = mod.MemberClass; cmd.Parameters.Add("@SchoolConsent", SqlDbType.NVarChar).Value = mod.SchoolConsent; cmd.Parameters.Add("@StudentIDCard", SqlDbType.NVarChar).Value = mod.StudentIDCard; cmd.Parameters.Add("@StudentIDCardFileType", SqlDbType.NVarChar).Value = mod.StudentIDCardFileType; cmd.Parameters.Add("@School", SqlDbType.NVarChar).Value = mod.School; cmd.Parameters.Add("@CollegeDepartment", SqlDbType.NVarChar).Value = mod.CollegeDepartment; cmd.Parameters.Add("@Education", SqlDbType.NVarChar).Value = mod.Education; cmd.Parameters.Add("@Job", SqlDbType.NVarChar).Value = mod.Job; cmd.Parameters.Add("@JobTitle", SqlDbType.NVarChar).Value = mod.JobTitle; cmd.Parameters.Add("@Student", SqlDbType.Bit).Value = mod.Student; cmd.Parameters.Add("@Mobile", SqlDbType.NVarChar).Value = mod.Mobile; cmd.Parameters.Add("@TEL", SqlDbType.NVarChar).Value = mod.TEL; cmd.Parameters.Add("@FAX", SqlDbType.NVarChar).Value = mod.FAX; cmd.Parameters.Add("@ZipCodeH", SqlDbType.NVarChar).Value = mod.ZipCodeH; cmd.Parameters.Add("@CityH", SqlDbType.NVarChar).Value = mod.CityH; cmd.Parameters.Add("@AreaH", SqlDbType.NVarChar).Value = mod.AreaH; cmd.Parameters.Add("@AddressH", SqlDbType.NVarChar).Value = mod.AddressH; cmd.Parameters.Add("@ZipCode", SqlDbType.NVarChar).Value = mod.ZipCode; cmd.Parameters.Add("@City", SqlDbType.NVarChar).Value = mod.City; cmd.Parameters.Add("@Area", SqlDbType.NVarChar).Value = mod.Area; cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = mod.Address; cmd.Parameters.Add("@Memo", SqlDbType.NVarChar).Value = mod.Memo; cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = mod.Status; cmd.Parameters.Add("@EDM", SqlDbType.Bit).Value = mod.EDM; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser; return(SQLUtil.ExecuteSql(cmd) > 0); }
public static string SniffData() { if (Storage.SniffData.IsEmpty()) { return(string.Empty); } if (Settings.DumpFormat != DumpFormatType.SniffDataOnly) { if (!Settings.SQLOutputFlag.HasAnyFlagBit(SQLOutput.SniffData) && !Settings.SQLOutputFlag.HasAnyFlagBit(SQLOutput.SniffDataOpcodes)) { return(string.Empty); } } var templateDb = SQLDatabase.Get(Storage.SniffData, Settings.WPPDatabase); return(SQLUtil.Compare(Storage.SniffData, templateDb, x => string.Empty)); }
/// <summary> /// 取得最新一筆Time資料 /// <summary> public Models.MTWYear GetTop1() { SqlCommand cmd = new SqlCommand("STP_TWYearGetTop1"); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = SQLUtil.QueryDR(cmd); bool isHasRows = dr.HasRows; Models.MTWYear mod = SetModel(dr); dr.Close(); if (isHasRows) { return(mod); } else { return(null); } }
/// <summary> /// 修改备用机信息 /// </summary> /// <param name="info">备用机信息</param> /// <returns>备用机id</returns> public int UpdateSpare(InvSpareInfo info) { sqlStr = "UPDATE tblInvSpare Set FujiClass2ID=@FujiClass2ID,SerialCode=@SerialCode,Price=@Price,StartDate=@StartDate,EndDate=@EndDate,UpdateDate=GetDate() " + " WHERE ID = @ID"; using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr)) { command.Parameters.Add("@ID", SqlDbType.Int).Value = info.ID; command.Parameters.Add("@FujiClass2ID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.FujiClass2.ID); command.Parameters.Add("@SerialCode", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.SerialCode); command.Parameters.Add("@Price", SqlDbType.Decimal).Value = info.Price; command.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.StartDate); command.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.EndDate); command.ExecuteNonQuery(); return(info.ID); } }
/// <summary> /// 耗材info /// </summary> /// <param name="dr">dr</param> public ConsumableInfo(DataRow dr) : this() { this.ID = SQLUtil.ConvertInt(dr["ID"]); this.FujiClass2.ID = SQLUtil.ConvertInt(dr["FujiClass2ID"]); this.FujiClass2.Name = SQLUtil.TrimNull(dr["FujiClass2Name"]); this.Name = SQLUtil.TrimNull(dr["Name"]); this.Description = SQLUtil.TrimNull(dr["Description"]); this.Type.ID = SQLUtil.ConvertInt(dr["TypeID"]); this.Type.Name = LookupManager.GetConsumabletypeDesc(this.Type.ID); this.ReplaceTimes = SQLUtil.ConvertDouble(dr["ReplaceTimes"]); this.CostPer = SQLUtil.ConvertDouble(dr["CostPer"]); this.StdPrice = SQLUtil.ConvertDouble(dr["StdPrice"]); this.IsIncluded = SQLUtil.ConvertBoolean(dr["IsIncluded"]); this.IncludeContract = SQLUtil.ConvertBoolean(dr["IncludeContract"]); this.IsActive = SQLUtil.ConvertBoolean(dr["IsActive"]); this.AddDate = SQLUtil.ConvertDateTime(dr["AddDate"]); this.UpdateDate = SQLUtil.ConvertDateTime(dr["UpdateDate"]); }
public static string AreaTriggerCreatePropertiesData() { var spellareatriggers = Storage.Objects.IsEmpty() ? new Dictionary <WowGuid, AreaTriggerCreateProperties>() // empty dict if there are no objects : Storage.Objects.Where( obj => obj.Value.Item1.Type == ObjectType.AreaTrigger && !obj.Value.Item1.IsTemporarySpawn()) // remove temporary spawns .OrderBy(pair => pair.Value.Item2) // order by spawn time .ToDictionary(obj => obj.Key, obj => obj.Value.Item1 as AreaTriggerCreateProperties); if (spellareatriggers.Count == 0) { return(string.Empty); } if (!Settings.SQLOutputFlag.HasAnyFlagBit(SQLOutput.areatrigger_create_properties)) { return(string.Empty); } var spellareatriggersData = new DataBag <AreaTriggerCreateProperties>(); foreach (var spellareatrigger in spellareatriggers) { spellareatriggersData.Add(spellareatrigger.Value); } var templateDb = SQLDatabase.Get(spellareatriggersData); return(SQLUtil.Compare(Settings.SQLOrderByKey ? spellareatriggersData.OrderBy(x => x.Item1.AreaTriggerId).ToArray() : spellareatriggersData.ToArray(), templateDb, x => { var comment = "SpellId : " + x.spellId.ToString(); if ((x.AreaTriggerCreatePropertiesId & 0x80000000) != 0) { comment += " CANNOT FIND PROPERTIES ID, USED SPELL ID AS KEY (NEEDS MANUAL CORRECTION)"; } return comment; })); }
/// <summary> /// 获取合同信息 /// </summary> /// <param name="dr">dataRow</param> public ContractInfo(DataRow dr) : this() { this.ID = SQLUtil.ConvertInt(dr["ID"]); this.ContractNum = SQLUtil.TrimNull(dr["ContractNum"]); this.Name = SQLUtil.TrimNull(dr["Name"]); this.Type.ID = SQLUtil.ConvertInt(dr["TypeID"]); this.Type.Name = Manager.LookupManager.GetContractTypeDesc(this.Type.ID); this.Scope.ID = SQLUtil.ConvertInt(dr["ScopeID"]); this.Scope.Name = LookupManager.GetContractScopeDesc(this.Scope.ID); this.ScopeComments = SQLUtil.TrimNull(dr["ScopeComments"]); this.Amount = SQLUtil.ConvertDouble(dr["Amount"]); this.ProjectNum = SQLUtil.TrimNull(dr["ProjectNum"]); this.StartDate = SQLUtil.ConvertDateTime(dr["StartDate"]); this.EndDate = SQLUtil.ConvertDateTime(dr["EndDate"]); this.Comments = SQLUtil.TrimNull(dr["Comments"]); this.Supplier.ID = SQLUtil.ConvertInt(dr["SupplierID"]); this.Supplier.Name = SQLUtil.TrimNull(dr["supplierName"]); }
public JsonResult Login(string loginID, string loginPwd) { ResultModel <UserInfo> result = new ResultModel <UserInfo>(); try { UserInfo existingInfo = this.userManager.GetUserByLoginID(loginID); if (existingInfo == null) { result.SetFailed(ResultCodes.BusinessError, "用户尚未注册"); } else if (existingInfo.LoginPwd != SQLUtil.TrimNull(loginPwd)) { result.SetFailed(ResultCodes.BusinessError, "用户名或密码不正确"); } else if (existingInfo.IsActive == false) { result.SetFailed(ResultCodes.BusinessError, "用户已停用"); } else if (existingInfo.VerifyStatus.ID != BusinessObjects.Domain.VerifyStatus.Pass) { result.SetFailed(ResultCodes.BusinessError, "用户尚未通过审批"); } else if (existingInfo.Role.ID == UserRole.User) { result.SetFailed(ResultCodes.BusinessError, "用户权限不足"); } else { existingInfo.WebSessionID = Guid.NewGuid().ToString(); existingInfo.LastLoginDate = DateTime.Now; this.userManager.UpdateLoginDate(existingInfo.ID, existingInfo.WebSessionID); SaveSession(existingInfo); result.Data = existingInfo; } } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(JsonResult(result)); }
public void UpdateComponents(List <ComponentInfo> infos, UserInfo userInfo) { List <ComponentInfo> existsInfos = this.QueryComponentsByIDs(infos.Select(info => info.ID).ToList()); foreach (ComponentInfo info in infos) { this.componentDao.UpdateComponent(info); } DataTable dt = FaultRateInfo.ConvertFaultRateDataTable(infos.SelectMany(component => component.FaultRates).ToList()); this.faultRateDao.UpdateFaultRates(dt); // 零件转换日志信息 infos.Sort(); existsInfos.Sort(); List <AuditHdrInfo> audits = new List <AuditHdrInfo>(); int len = existsInfos.Count; for (int i = 0; i < len; i++) { AuditHdrInfo audit = existsInfos[i].ConvertAudit(infos[i], userInfo); audit.DetailInfo = audit.DetailInfo.Concat(FaultRateInfo.ConvertAuditDetail(existsInfos[i].FaultRates, infos[i].FaultRates)).ToList(); //if(audit.DetailInfo.Count>0) audits.Add(audit); } DataTable auditDT = audits.ConvertAuditDT(); DataTable auditDetailDT = null; this.auditDao.AddAuditHdr(auditDT); for (int i = 0; i < len; i++) { if (auditDetailDT == null) { auditDetailDT = audits[i].DetailInfo.ConvertAuditDetailDT(SQLUtil.ConvertInt(auditDT.Rows[i]["ID"])); } else { auditDetailDT.Merge(audits[i].DetailInfo.ConvertAuditDetailDT(SQLUtil.ConvertInt(auditDT.Rows[i]["ID"]))); } } this.auditDao.AddAuditDetail(auditDetailDT); }
private void Search() { DataTable dtProducts = null; ProductParameters pmtProduct = new ProductParameters(); pmtProduct.Name = SQLUtil.CreateSearchQueryCondition( this.frmProduct.txtSchName.Text.Trim(), SQLUtil.SearchQueryConditionsEnum.AND); pmtProduct.ProductBrandId = this.frmProduct.pbcSchProductBrand.Value == null ? -1 : this.frmProduct.pbcSchProductBrand.Value.ProductBrandId; try { dtProducts = srvProduct.SearchByParameters("Product.Search100Products", pmtProduct, false); } catch { } this.frmProduct.grdSchSearch.DataSource = null; this.frmProduct.grdSchSearch.DataSource = dtProducts; }
/// <summary> /// 實體物件取得DataRow資料 /// </summary> private Models.MMemberP SetModel(DataRow dr) { Models.MMemberP mod = new Models.MMemberP(); mod.MemberPID = dr["MemberPID"].ToString(); mod.MemberPassword = dr["MemberPassword"].ToString(); mod.NameC = dr["NameC"].ToString(); mod.NameE = dr["NameE"].ToString(); mod.Email = dr["Email"].ToString(); mod.PID = dr["PID"].ToString(); mod.Birthday = SQLUtil.GetDateTime(dr["Birthday"]); mod.RegisterDate = DateTime.Parse(dr["RegisterDate"].ToString()); mod.Sex = dr["Sex"].ToString(); mod.Native = dr["Native"].ToString(); mod.MemberClass = dr["MemberClass"].ToString(); mod.SchoolConsent = dr["SchoolConsent"].ToString(); mod.StudentIDCard = dr["StudentIDCard"].ToString(); mod.StudentIDCardFileType = dr["StudentIDCardFileType"].ToString(); mod.School = dr["School"].ToString(); mod.CollegeDepartment = dr["CollegeDepartment"].ToString(); mod.Education = dr["Education"].ToString(); mod.Job = dr["Job"].ToString(); mod.JobTitle = dr["JobTitle"].ToString(); mod.Student = bool.Parse(dr["Student"].ToString()); mod.Mobile = dr["Mobile"].ToString(); mod.TEL = dr["TEL"].ToString(); mod.FAX = dr["FAX"].ToString(); mod.ZipCodeH = dr["ZipCodeH"].ToString(); mod.CityH = dr["CityH"].ToString(); mod.AreaH = dr["AreaH"].ToString(); mod.AddressH = dr["AddressH"].ToString(); mod.ZipCode = dr["ZipCode"].ToString(); mod.City = dr["City"].ToString(); mod.Area = dr["Area"].ToString(); mod.Address = dr["Address"].ToString(); mod.Memo = dr["Memo"].ToString(); mod.Status = dr["Status"].ToString(); mod.EDM = bool.Parse(dr["EDM"].ToString()); mod.CreateUser = dr["CreateUser"].ToString(); mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString()); mod.UpdateUser = dr["UpdateUser"].ToString(); mod.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString()); return(mod); }
public static string GameObjectTemplate(Dictionary <WowGuid, GameObject> gameobjects) { if (!Settings.SQLOutputFlag.HasAnyFlagBit(SQLOutput.gameobject_template)) { return(string.Empty); } if (Storage.GameObjectTemplates.IsEmpty()) { return(string.Empty); } var templatesDb = SQLDatabase.Get(Storage.GameObjectTemplates); foreach (var goT in Storage.GameObjectTemplates) { GameObject go = gameobjects.FirstOrDefault(p => p.Key.GetEntry() == goT.Item1.Entry.GetValueOrDefault()).Value; if (go != null) { if (goT.Item1.Size == null) // only true for 3.x and 4.x. WDB field since 5.x { goT.Item1.Size = go.Size.GetValueOrDefault(1.0f); } HashSet <uint> playerFactions = new HashSet <uint> { 1, 2, 3, 4, 5, 6, 115, 116, 1610, 1629, 2203, 2204 }; goT.Item1.Faction = go.Faction.GetValueOrDefault(0); if (playerFactions.Contains(go.Faction.GetValueOrDefault())) { goT.Item1.Faction = 0; } goT.Item1.Flags = go.Flags.GetValueOrDefault(GameObjectFlag.None); goT.Item1.Flags &= ~GameObjectFlag.Triggered; goT.Item1.Flags &= ~GameObjectFlag.Damaged; goT.Item1.Flags &= ~GameObjectFlag.Destroyed; } } return(SQLUtil.Compare(Storage.GameObjectTemplates, templatesDb, StoreNameType.GameObject)); }
private void BindReuseData(int id) { object[] param = new object[2]; param[0] = id; param[1] = User.Identity.Name; String sql = "SELECT * from ReuseTech where Id=@id and Username=@Username"; OleDbCommand cmd = new OleDbCommand(sql); cmd.Parameters.Add("@id", OleDbType.VarChar).Value = param[0]; cmd.Parameters.Add("@Username", OleDbType.VarChar).Value = param[1]; cmd.CommandType = CommandType.Text; DataSet ds = SQLUtil.QueryDS(cmd); // IList lists = mgr.getReuseTechList(param); DetailsView1.DataSource = ds; DetailsView1.DataKeyNames = new string[] { "Id" }; DetailsView1.DataBind(); }
protected void BindList() { //at = SpringUtil.at(); String sql = "SELECT Id,Name,Pid "; sql += " from Zip where Pid=@param1 "; //IDbParameters parameters = at.CreateDbParameters(); //parameters.Add("param1", OleDbType.Char).Value = ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("cityList")).SelectedValue; //DataSet ds = new DataSet(); //at.DataSetFillWithParameters(ds, CommandType.Text, sql, parameters); OleDbCommand cmd = new OleDbCommand(sql); cmd.Parameters.AddWithValue("?", ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("cityList")).SelectedValue); zipList.DataSource = SQLUtil.QueryDS(cmd); zipList.DataTextField = "Name"; zipList.DataValueField = "Id"; zipList.DataBind(); }
public Case getCase(int obj) { String sql = " SELECT Id,casedesc,createdate,helpdesc,isdeleted,name ,techitem ,techname ,techother ,type ,wasteitem ,wastename ,wasteother ,datasource FROM ReuseCase where Id=@Id "; OleDbCommand cmd = new OleDbCommand(sql); cmd.Parameters.Add("@Id", OleDbType.Integer).Value = obj; cmd.CommandType = CommandType.Text; DataSet ds = SQLUtil.QueryDS(cmd); IList lists = GetList(ds); if (lists == null || lists.Count < 1) { return(null); } else { return((Case)lists[0]); } }
private void BindGrid(string type) { //at = SpringUtil.at(); /* 帳號未審核 */ String sql = "SELECT IsApproved, UserId,UserName,Email,CreateDate,'' as Type,'' as Name,'' as Corp,'' as Tel "; sql += " from vw_aspnet_MembershipUsers "; if (type.Equals("A")) { sql += " where IsApproved=false "; } else if (type.Equals("B")) { sql += " where UserName not in ('isrmng','root') "; } if (!qryText.Text.Trim().Equals("")) { sql += " and Comment like '%" + qryText.Text.Trim() + "%'"; } //DataSet ds = new DataSet(); //at.DataSetFill(ds, CommandType.Text, sql); OleDbCommand cmd = new OleDbCommand(sql); DataSet ds = SQLUtil.QueryDS(cmd); foreach (DataRow dRow in ds.Tables[0].Rows) { p = Profile.GetProfile(dRow["UserName"].ToString()); dRow["Type"] = p.UserProfile.Type; dRow["Name"] = p.UserProfile.Name; dRow["Corp"] = p.UserProfile.Corp; dRow["Tel"] = p.UserProfile.Tel; } ApproveGrid.DataSource = ds; ApproveGrid.DataBind(); cnt.Text = Convert.ToString(ds.Tables[0].Rows.Count); }
protected void AppendBtn_Click(object sender, EventArgs e) { News obj = new News(); obj.Title = Title1.Text; obj.Showdate = DateTime.ParseExact(Showdate1.Text, "yyyy/M/d", null); obj.Createdate = DateTime.Now; obj.Summary = Summary1.Text; obj.Link = Link1.Text; obj.Isonline = IsOnLine1.SelectedValue; if (IsShow1.SelectedValue.Equals("Y")) { obj.Isshow = true; } else { obj.Isshow = false; } /*Add*/ String sqlM = ""; sqlM = sqlM + " insert into News ([Createdate],[Isonline],[Isshow],[Link],[Showdate],[Summary],[Title])"; sqlM = sqlM + " values (@Createdate,@Isonline,@Isshow,@Link,@Showdate,@Summary,@Title)"; OleDbCommand cmdM = new OleDbCommand(sqlM); cmdM.Parameters.Add("@Createdate", OleDbType.Date).Value = obj.Createdate; cmdM.Parameters.Add("@Isonline", OleDbType.VarChar).Value = obj.Isonline; cmdM.Parameters.Add("@Isshow", OleDbType.Boolean).Value = obj.Isshow; cmdM.Parameters.Add("@Link", OleDbType.VarChar).Value = obj.Link; cmdM.Parameters.Add("@Showdate", OleDbType.Date).Value = obj.Showdate; cmdM.Parameters.Add("@Summary", OleDbType.VarChar).Value = obj.Summary; cmdM.Parameters.Add("@Title", OleDbType.VarChar).Value = obj.Title; cmdM.CommandType = CommandType.Text; SQLUtil.ExecuteSql(cmdM); //mgr.Save(obj); BindGrid(); MultiView1.ActiveViewIndex = 0; }
/// <summary> /// 新增資料 /// </summary> public string Add(Models.MMemberG mod) { SqlCommand cmd = new SqlCommand("STP_MemberGAdd"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberGID", SqlDbType.NVarChar).Value = mod.MemberGID; cmd.Parameters.Add("@MemberGassword", SqlDbType.NVarChar).Value = mod.MemberGassword; cmd.Parameters.Add("@NameC", SqlDbType.NVarChar).Value = mod.NameC; cmd.Parameters.Add("@MemberClass", SqlDbType.NVarChar).Value = mod.MemberClass; cmd.Parameters.Add("@TEL", SqlDbType.NVarChar).Value = mod.TEL; cmd.Parameters.Add("@FAX", SqlDbType.NVarChar).Value = mod.FAX; cmd.Parameters.Add("@RegisterDate", SqlDbType.DateTime).Value = mod.RegisterDate; cmd.Parameters.Add("@ZipCode", SqlDbType.NVarChar).Value = mod.ZipCode; cmd.Parameters.Add("@City", SqlDbType.NVarChar).Value = mod.City; cmd.Parameters.Add("@Area", SqlDbType.NVarChar).Value = mod.Area; cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = mod.Address; cmd.Parameters.Add("@ContactName", SqlDbType.NVarChar).Value = mod.ContactName; cmd.Parameters.Add("@ContactTitle", SqlDbType.NVarChar).Value = mod.ContactTitle; cmd.Parameters.Add("@ContactTEL", SqlDbType.NVarChar).Value = mod.ContactTEL; cmd.Parameters.Add("@ContactMobile", SqlDbType.NVarChar).Value = mod.ContactMobile; cmd.Parameters.Add("@ContactEmail", SqlDbType.NVarChar).Value = mod.ContactEmail; cmd.Parameters.Add("@AgentName", SqlDbType.NVarChar).Value = mod.AgentName; cmd.Parameters.Add("@AgentTitle", SqlDbType.NVarChar).Value = mod.AgentTitle; cmd.Parameters.Add("@AgentTEL", SqlDbType.NVarChar).Value = mod.AgentTEL; cmd.Parameters.Add("@AgentMobile", SqlDbType.NVarChar).Value = mod.AgentMobile; cmd.Parameters.Add("@AgentEmail", SqlDbType.NVarChar).Value = mod.AgentEmail; cmd.Parameters.Add("@Memo", SqlDbType.NVarChar).Value = mod.Memo; cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = mod.Status; cmd.Parameters.Add("@EDM", SqlDbType.Bit).Value = mod.EDM; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser; cmd.Parameters.Add("@JobContent", SqlDbType.NVarChar).Value = mod.JobContent; cmd.Parameters.Add("@CompanyID", SqlDbType.NVarChar).Value = mod.CompanyID; if (SQLUtil.ExecuteSql(cmd) > 0) { return(mod.MemberGID); } else { return(null); } }
/// <summary> /// 取得單筆資料 /// <summary> public Models.MMemberG GetModel(string strMemberGID) { SqlCommand cmd = new SqlCommand("STP_MemberGGetByPK"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberGID", SqlDbType.NVarChar).Value = strMemberGID; SqlDataReader dr = SQLUtil.QueryDR(cmd); bool isHasRows = dr.HasRows; Models.MMemberG mod = SetModel(dr); dr.Close(); if (isHasRows) { return(mod); } else { return(null); } }
/// <summary> /// 更新请求信息 /// </summary> /// <param name="info">请求信息</param> public void UpdateRequest(RequestInfo info) { sqlStr = " UPDATE tblRequest SET Subject=@Subject,EquipmentStatus=@EquipmentStatus,FaultTypeID=@FaultTypeID,FaultDesc=@FaultDesc,StatusID=@StatusID, " + " LastStatusID=@LastStatusID,DealTypeID=@DealTypeID,PriorityID=@PriorityID,IsRecall=@IsRecall " + " WHERE ID=@ID "; using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr)) { command.Parameters.Add("@Subject", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Subject); command.Parameters.Add("@EquipmentStatus", SqlDbType.Int).Value = info.MachineStatus.ID; command.Parameters.Add("@FaultTypeID", SqlDbType.Int).Value = SQLUtil.ZeroToNull(info.FaultType.ID); command.Parameters.Add("@FaultDesc", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.FaultDesc); command.Parameters.Add("@StatusID", SqlDbType.Int).Value = info.Status.ID; command.Parameters.Add("@LastStatusID", SqlDbType.Int).Value = info.LastStatus.ID; command.Parameters.Add("@DealTypeID", SqlDbType.Int).Value = info.DealType.ID; command.Parameters.Add("@PriorityID", SqlDbType.Int).Value = info.Priority.ID; command.Parameters.Add("@ID", SqlDbType.Int).Value = info.ID; command.Parameters.Add("@IsRecall", SqlDbType.Bit).Value = info.IsRecall; command.ExecuteNonQuery(); } }
/// <summary> /// 添加采购单 /// </summary> /// <param name="info">采购单信息</param> /// <returns>采购单id</returns> public int AddPurchaseOrder(PurchaseOrderInfo info) { sqlStr = "INSERT INTO tblPurchaseOrder(UserID,SupplierID,OrderDate,DueDate,Comments,StatusID,AddDate) " + " VALUES(@UserID,@SupplierID,@OrderDate,@DueDate,@Comments,@StatusID,GetDate()); " + " SELECT @@IDENTITY "; using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr)) { command.Parameters.Add("@UserID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.User.ID); command.Parameters.Add("@SupplierID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Supplier.ID); command.Parameters.Add("@OrderDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.OrderDate); command.Parameters.Add("@DueDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.DueDate); command.Parameters.Add("@Comments", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Comments); command.Parameters.Add("@StatusID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Status.ID); info.ID = SQLUtil.ConvertInt(command.ExecuteScalar()); return(info.ID); } }
/// <summary> /// 修改采购单信息 /// </summary> /// <param name="info">采购单信息</param> /// <returns>采购单id</returns> public int UpdatePurchaseOrder(PurchaseOrderInfo info) { sqlStr = "UPDATE tblPurchaseOrder Set UserID=@UserID,SupplierID=@SupplierID,OrderDate=@OrderDate,DueDate=@DueDate,Comments=@Comments,StatusID=@StatusID,UpdateDate=GetDate() " + " WHERE ID = @ID"; using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr)) { command.Parameters.Add("@ID", SqlDbType.Int).Value = info.ID; command.Parameters.Add("@UserID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.User.ID); command.Parameters.Add("@SupplierID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Supplier.ID); command.Parameters.Add("@OrderDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.OrderDate); command.Parameters.Add("@DueDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.DueDate); command.Parameters.Add("@Comments", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Comments); command.Parameters.Add("@StatusID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Status.ID); command.ExecuteNonQuery(); return(info.ID); } }
public static string Gossip() { var result = ""; // `gossip_menu` if (!Storage.Gossips.IsEmpty() && Settings.SQLOutputFlag.HasAnyFlagBit(SQLOutput.gossip_menu)) { result += SQLUtil.Compare(Storage.Gossips, SQLDatabase.Get(Storage.Gossips), t => StoreGetters.GetName(StoreNameType.Unit, (int)t.ObjectEntry)); // BUG: GOs can send gossips too } // `gossip_menu_option` if (!Storage.GossipMenuOptions.IsEmpty() && Settings.SQLOutputFlag.HasAnyFlagBit(SQLOutput.gossip_menu_option)) { var store = Settings.SQLOrderByKey ? Storage.GossipMenuOptions.Values.OrderBy(x => x.Item1.MenuID).ThenBy(y => y.Item1.OptionID).ToArray() : Storage.GossipMenuOptions.Values; result += SQLUtil.Compare(store, SQLDatabase.Get(Storage.GossipMenuOptions.Values), t => t.BroadcastTextIDHelper); } return(result); }
/// <summary> /// 取得單筆資料 /// <summary> public Models.MOnSiteRegistration GetModel(int intOnSiteRegistrationID) { SqlCommand cmd = new SqlCommand("STP_OnSiteRegistrationGetByPK"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@OnSiteRegistrationID", SqlDbType.Int).Value = intOnSiteRegistrationID; SqlDataReader dr = SQLUtil.QueryDR(cmd); bool isHasRows = dr.HasRows; Models.MOnSiteRegistration mod = SetModel(dr); dr.Close(); if (isHasRows) { return(mod); } else { return(null); } }
/// <summary> /// 取得單筆資料 /// <summary> public Models.MTWYear GetModel(int intTWYear) { SqlCommand cmd = new SqlCommand("STP_TWYearGetByPK"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = intTWYear; SqlDataReader dr = SQLUtil.QueryDR(cmd); bool isHasRows = dr.HasRows; Models.MTWYear mod = SetModel(dr); dr.Close(); if (isHasRows) { return(mod); } else { return(null); } }
public IList <DTOProtocolo> ListarHistorico(string cpf, string protocolo = null, string discriminacao = null, string dtaEnvio = null, string dtaRecebimento = null, string remetente = null, string destinatario = null, string statusId = null, int todos = 0) { Dictionary <string, object> parametros = new Dictionary <string, object>(); parametros.Add("P_CpfUsuario", cpf); parametros.Add("P_NumProtocolo", protocolo); parametros.Add("P_TxtDiscriminacao", discriminacao); parametros.Add("P_DtaEnvio", dtaEnvio); parametros.Add("P_DtaRecebimento", dtaRecebimento); parametros.Add("P_NomRemetente", remetente); parametros.Add("P_NomDestinatario", destinatario); parametros.Add("P_StatusID", statusId); if (todos > 0) { parametros.Add("P_Todos", 1); } return(SQLUtil.ExecutarProcedure <DTOProtocolo>("SP_ProtocoloHistorico", parametros).OrderByDescending(x => x.Numero).ToList()); }
private void GetReplyBossMsg(string view, ReplyType type) { DataTable dt = SQLUtil.GetReplyBossMsg(m_Connstr, view); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { ReplyBossMsg reply = IdlUtil.ParseReplyFromDataRow(dr); ReplyBossMsgExtend replyExtend = new ReplyBossMsgExtend(reply, type); if (!m_ReplyBossMsgs.Contains(replyExtend) && !CheckAlreadyWork(replyExtend)) { lock (m_ReplyBossMsgs) { m_ReplyBossMsgs.Enqueue(replyExtend); } } } } }
public bool CheckComponent(string serialCode, int type) { sqlStr = "SELECT COUNT(ID) FROM tblReportComponent WHERE 1=1 "; if (type == ReportComponentInfo.FileTypes.New) { sqlStr += " AND NewSerialCode = @SerialCode "; } if (type == ReportComponentInfo.FileTypes.Old) { sqlStr += " AND OldSerialCode = @SerialCode "; } using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr)) { command.Parameters.Add("@SerialCode", SqlDbType.NVarChar).Value = serialCode; return(SQLUtil.ConvertInt(command.ExecuteScalar()) > 0); } }
/// <summary> /// 新增資料 /// </summary> public string Add(Models.MUser mod) { SqlCommand cmd = new SqlCommand("STP_UserAdd"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = mod.UserID; cmd.Parameters.Add("@UserPassword", SqlDbType.NVarChar).Value = Security.Encrypt(mod.UserPassword); cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = mod.UserName; cmd.Parameters.Add("@Actived", SqlDbType.Bit).Value = mod.Actived; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser; if (SQLUtil.ExecuteSql(cmd) > 0) { return(mod.UserID); } else { return(null); } }