/// <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);
}
}
