/// <summary> /// Sets the datatype on the Filter- en DataFields of the SQLBuilder /// </summary> /// <param name="sqlb">SQLBuilder</param> public void SetFieldDataTypes(SQLBuilder sqlb) { XSDAdapter xsda = xsdAdapterFactory.Create(PhysicalAppPath); SetFilterFieldDataTypes(sqlb, xsda); SetDataFieldDataTypes(sqlb, xsda); }
public void SetFieldDataTypes(SQLBuilder sqlb) { XSDAdapter xsda = new XSDAdapter(PhysicalAppPath); SetFilterFieldDataTypes(sqlb, xsda); SetDataFieldDataTypes(sqlb, xsda); }
public void GetFieldDataTypes(SQLBuilder sqlb) { XSDAdapter xsda = new XSDAdapter(_physappath); SetFilterFieldDataTypes(sqlb, xsda); SetDataFieldDataTypes(sqlb, xsda); }
private static void SetFilterFieldsDataType(SQLBuilder sqlb, string[] datatypes) { int u = datatypes.GetUpperBound(0); for (int i = 0; i <= u; i++) { FilterField ffield = sqlb.FilterFields.Item(i); ffield.DataType = datatypes[i]; } }
internal static string WhereSql(Query query) { SQLBuilder builder = new SQLBuilder(); builder.AppendWhere(); builder.Append(query.DirectoryId > 0, "and", "directory_id=@DirectoryId"); builder.Append(!string.IsNullOrWhiteSpace(query.Name), "and", "api_name like '%" + query.Name + "%'"); return builder.Sql(); }
private void TestForm_Shown(object sender, EventArgs e) { IDbAdapter adapter = new SQLiteDataAdapter(); DataService = new DataService {Adapter = adapter}; Builder = new SQLBuilder(DataService.Adapter); Builder.CreateStructure(); List<Equipment> users = DataService.GetAllForModel(ModelExtensions.CreateInstance<Equipment>); Grid.DataSource = users; }
private static string[] GetDataFieldNames(SQLBuilder sqlb) { var al_fields = new ArrayList(); foreach (DataField dfield in sqlb.DataFields) { al_fields.Add(dfield.Name); } return (string[]) al_fields.ToArray(typeof (string)); }
private static string WhereSql(Model.ServiceStatMinute.Query query) { SQLBuilder builder = new SQLBuilder(); builder.AppendWhere(); builder.Append(query.StatTimeStart != null, "and", "stat_time>@StatTimeStart"); builder.Append(query.StatTimeEnd != null, "and", "stat_time<=@StatTimeEnd"); builder.Append(!string.IsNullOrWhiteSpace(query.ServiceName), "and", "service_name=@ServiceName"); return builder.Sql(); }
private void SetDataFieldDataTypes(SQLBuilder sqlb, XSDAdapter xsda) { //only get datafield types when not sql select or sql delete if (sqlb.SQLtype != snpSQLtype.sqlSelect && sqlb.SQLtype != snpSQLtype.sqlDelete) { string[] fields = GetDataFieldNames(sqlb); string[] datatypes = xsda.GetDataTypes(_xsdn, fields); SetDataFieldsDataType(sqlb, datatypes); } }
private static void SetFilterFieldsDataType(SQLBuilder sqlb, string[] datatypes) { //SMELL : bijna DRY-violation met SetDataFieldsDataType //misschien in 1 functie "SetFieldDataType" verenigen ? int u = datatypes.GetUpperBound(0); for (int i = 0; i <= u; i++) { FilterField ffield = sqlb.FilterFields.Item(i); ffield.DataType = datatypes[i]; } }
/// <summary> /// 添加实体 /// </summary> /// <param name="addressBookEntity">实体对象</param> /// <returns>代码</returns> public String AddEntity(BaseAdviceEntity myAdviceEntity) { String id = BaseSequenceDao.Instance.NewGuid(); SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper); sqlBuilder.BeginInsert(BaseAdviceTable.TableName); sqlBuilder.SetValue(BaseAdviceTable.FieldID, id); this.SetEntity(sqlBuilder, myAdviceEntity); if (this.UserInfo != null) { sqlBuilder.SetValue(BaseAdviceTable.FieldCreateUserID, this.UserInfo.ID); } sqlBuilder.SetDBNow(BaseAdviceTable.FieldCreateDate); return sqlBuilder.EndInsert() > 0 ? id : String.Empty; }
/// <summary> /// ���һ����¼ /// </summary> /// <param name="mySend">���Ķ���</param> /// <returns>����</returns> public override String AddEntity(Object myObject) { String id = BaseSequenceDao.Instance.GetSequence(this.DbHelper, BaseAttchmentTable.TableName); BaseAttchmentEntity myAttchment = (BaseAttchmentEntity)myObject; SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper); sqlBuilder.BeginInsert(BaseAttchmentTable.TableName); sqlBuilder.SetValue(BaseAttchmentTable.FieldID, id); sqlBuilder.SetValue(BaseAttchmentTable.FieldCategoryID, myAttchment.CategoryID); sqlBuilder.SetValue(BaseAttchmentTable.FieldObjectID, myAttchment.ObjectID); sqlBuilder.SetValue(BaseAttchmentTable.FieldFileName, myAttchment.FileName); sqlBuilder.SetValue(BaseAttchmentTable.FieldDescription, myAttchment.Description); sqlBuilder.SetValue(BaseAttchmentTable.FieldCreateUserID, this.UserInfo.ID); sqlBuilder.SetDBNow(BaseAttchmentTable.FieldCreateDate); sqlBuilder.SetDBNow(BaseAttchmentTable.FieldModifyDate); return sqlBuilder.EndInsert() > 0 ? id : String.Empty; }
public CrossTabulationViewControl(SQLBuilder.SelectQueryBuilder QuerryBuilder, string CurrentDatabaseName) { InitializeComponent(); result = new ResultViewModel(QuerryBuilder, CurrentDatabaseName); if (result != null) { this.DataContext = result; if (result.QueryBulder != null) { if (result.QueryBulder.SelectedTables.Count != 0) { _tableName = result.QueryBulder.SelectedTables[0].Name; } } } PopulateCrossTabulationViewControl(QuerryBuilder); }
private static string[] GetFilterFieldNames(SQLBuilder sqlb) { ArrayList al_fields = new ArrayList(); if (sqlb.DDLDataFilterField > 0) { DataField dfield = sqlb.DataFields.Item(sqlb.DDLDataFilterField - 1); al_fields.Add(dfield.Name); } else { foreach (FilterField ffield in sqlb.FilterFields) { al_fields.Add(ffield.Name); } } return (string[])al_fields.ToArray(typeof(string)); }
private void SetFilterFieldDataTypes(SQLBuilder sqlb, XSDAdapter xsda) { if (sqlb.FilterFields.Count > 0) { string[] datatypes = GetFilterFieldDataTypes(sqlb, xsda); SetFieldDataType(sqlb, datatypes, typeof (FilterField)); } }
/// <summary> /// 更新实体 /// </summary> /// <param name="addressBookEntity">实体对象</param> /// <returns>影响行数</returns> public int UpdateEntity(BaseAdviceEntity myAdviceEntity) { SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper); sqlBuilder.BeginUpdate(BaseAdviceTable.TableName); this.SetEntity(sqlBuilder, myAdviceEntity); sqlBuilder.SetValue(BaseAdviceTable.FieldModifyUserID, this.UserInfo.ID); sqlBuilder.SetDBNow(BaseAdviceTable.FieldModifyDate); sqlBuilder.SetWhere(BaseAdviceTable.FieldID, myAdviceEntity.ID); return sqlBuilder.EndUpdate(); }
private void SetDataFieldDataTypes(SQLBuilder sqlb, XSDAdapter xsda) { //SMELL : functie met duidelijk naam ipv. comment //SMELL : level of abstraction //only get datafield types when not sql select or sql delete if (sqlb.SQLtype != snpSQLtype.sqlSelect && sqlb.SQLtype != snpSQLtype.sqlDelete) { //SMELL : "fields" en "datatypes" //kunnen samengebracht worden in 1 nieuwe functie : //GetFilterFieldDatatypes //dat onmiddellijk string[] datatypes teruggeeft string[] fields = GetDataFieldNames(sqlb); string[] datatypes = xsda.GetDataTypes(XsdName, fields); //end SMELL SetDataFieldsDataType(sqlb, datatypes); } }
// 这个是声明扩展方法 partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseWorkFlowBillTemplateEntity baseWorkFlowBillTemplateEntity);
/// <summary> /// 添加实体 /// </summary> /// <param name="baseWorkFlowBillTemplateEntity">实体</param> public string AddEntity(BaseWorkFlowBillTemplateEntity baseWorkFlowBillTemplateEntity) { string sequence = string.Empty; this.Identity = false; if (baseWorkFlowBillTemplateEntity.SortCode == null || baseWorkFlowBillTemplateEntity.SortCode == 0) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); baseWorkFlowBillTemplateEntity.SortCode = int.Parse(sequence); } if (baseWorkFlowBillTemplateEntity.Id != null) { sequence = baseWorkFlowBillTemplateEntity.Id.ToString(); } SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, BaseWorkFlowBillTemplateEntity.FieldId); if (!this.Identity) { if (string.IsNullOrEmpty(baseWorkFlowBillTemplateEntity.Id)) { sequence = BaseBusinessLogic.NewGuid(); baseWorkFlowBillTemplateEntity.Id = sequence; } sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldId, baseWorkFlowBillTemplateEntity.Id); } else { if (!this.ReturnId && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2)) { if (DbHelper.CurrentDbType == DbTypes.Oracle) { sqlBuilder.SetFormula(BaseWorkFlowBillTemplateEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DbHelper.CurrentDbType == DbTypes.DB2) { sqlBuilder.SetFormula(BaseWorkFlowBillTemplateEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2)) { if (string.IsNullOrEmpty(baseWorkFlowBillTemplateEntity.Id)) { if (string.IsNullOrEmpty(sequence)) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); } baseWorkFlowBillTemplateEntity.Id = sequence; } sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldId, baseWorkFlowBillTemplateEntity.Id); } } } this.SetEntity(sqlBuilder, baseWorkFlowBillTemplateEntity); if (UserInfo != null) { sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldCreateUserId, UserInfo.Id); sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldCreateBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseWorkFlowBillTemplateEntity.FieldCreateOn); if (UserInfo != null) { sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseWorkFlowBillTemplateEntity.FieldModifiedOn); if (this.Identity && (DbHelper.CurrentDbType == DbTypes.SqlServer || DbHelper.CurrentDbType == DbTypes.Access)) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
// 这个是声明扩展方法 partial void SetObjectExpand(SQLBuilder sqlBuilder, ZtoPrintHistoryEntity entity);
partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseUserRoleEntity userRoleEntity);
/// <summary> /// 添加实体 /// </summary> /// <param name="entity">实体</param> public string AddObject(ZtoPrintBillEntity entity, string dataSource = "0") { string key = string.Empty; if (entity.Id != null) { key = entity.Id.ToString(); } SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, this.PrimaryKey); if (!this.Identity) { // 这里已经是指定了主键了,所以不需要返回主键了 sqlBuilder.ReturnId = false; sqlBuilder.SetValue(this.PrimaryKey, entity.Id); } else { if (!this.ReturnId && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2)) { if (DbHelper.CurrentDbType == CurrentDbType.Oracle) { sqlBuilder.SetFormula(this.PrimaryKey, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DbHelper.CurrentDbType == CurrentDbType.DB2) { sqlBuilder.SetFormula(this.PrimaryKey, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2)) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper); // entity.Id = sequenceManager.Increment(this.CurrentTableName); sqlBuilder.SetValue(this.PrimaryKey, entity.Id); } } } this.SetObject(sqlBuilder, entity, dataSource); //if (entity.CreateOn.Year != 1) //{ // sqlBuilder.SetValue(ZtoPrintBillEntity.FieldCreateOn, entity.CreateOn); //} //else //{ sqlBuilder.SetDBNow(ZtoPrintBillEntity.FieldCreateOn); //} sqlBuilder.SetDBNow(ZtoPrintBillEntity.FieldModifiedOn); if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.SqlServer || DbHelper.CurrentDbType == CurrentDbType.Access)) { key = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2)) { return(entity.Id.ToString()); } return(key); }
private void SetFilterFieldDataTypes(SQLBuilder sqlb, XSDAdapter xsda) { if (sqlb.FilterFields.Count > 0) { string[] fields = GetFilterFieldNames(sqlb); string[] datatypes = xsda.GetDataTypes(_xsdn, fields); SetFilterFieldsDataType(sqlb, datatypes); } }
partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseNewsEntity newsEntity);
protected void Page_Load(object sender, EventArgs e) { string action = Com.Util.getStringByObject(Request["action"]); string Get_Authcode = ""; string Sys_Authcode = ""; DataTable dt; SQLBuilder builder = new CSA.DAL.SQLBuilder(); SQLBuilder builder2 = new CSA.DAL.SQLBuilder(); switch (action) { case "addMsg": if (Request.Form["checkcode"].ToString().ToLower() == Session[Common.HNKeys.SESSION_CODE].ToString().ToLower()) { builder = new CSA.DAL.SQLBuilder("Bs_Msg"); builder.AddData("IP", CSA.HC.Common.getIP()); builder.AddData("Name", Com.Util.getStringByObject(Request.Form["name"])); builder.AddData("Email", Com.Util.getStringByObject(Request.Form["email"])); builder.AddData("Phone", Com.Util.getStringByObject(Request.Form["phone"])); builder.AddData("Company", Com.Util.getStringByObject(Request.Form["company"])); builder.AddData("Content", Com.Util.getStringByObject(Request.Form["content"])); builder.AddData("addtime", DateTime.Now.ToString("s")); builder.AddData("Sy_CodeMT", "0101"); if (builder.AutoInsert()) { Response.Write("{\"status\":\"success\",\"content\":\"提交成功!\"}"); } else { Response.Write("{\"status\":\"error\",\"content\":\"提交失败!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"验证码错误!\"}"); } break; #region ========= out 登出 case "logout": Factory.getUserBllInstance().logout(); Response.Write("{\"status\":\"success\",\"content\":\"退出成功!\"}"); break; #endregion #region ========= log 登陆 case "log": //登陆 Get_Authcode = Com.Util.getStringByObject(Request.Form["checkcode"]).ToLower(); Sys_Authcode = Com.Util.getStringByObject(Session[Common.HNKeys.SESSION_CODE]).ToLower(); string login_name = Com.Util.getStringByObject(Request.Form["mobile"]); string login_pwd = Com.Util.getStringByObject(Request.Form["password"]); if (Get_Authcode == Sys_Authcode) { if (login_name == "" || login_name == "") { Response.Write("{\"status\":\"error\",\"content\":\"读取登陆信息失败,请重新登陆!\"}"); } else { if (CurInfo.CurUser != null) { Factory.getUserBllInstance().logout(); } Bs_User user = new Bs_User(); user.Mobile = login_name; user.Password = login_pwd; user.Bs_UserGradeCode = "01"; Factory.getUserBllInstance().login(user); if (CurInfo.CurUser == null) { Response.Write("{\"status\":\"error\",\"content\":\"账号或密码错误!\"}"); } else { Response.Write("{\"status\":\"success\",\"content\":\"登陆成功!\"}"); } } } else { Response.Write("{\"status\":\"error\",\"content\":\"验证码错误!\"}"); return; } break; #endregion #region ========= reg 注册 case "reg": //注册 Get_Authcode = Com.Util.getStringByObject(Request.Form["msgcode"]).ToLower(); string Name = Com.Util.getStringByObject(Request.Form["mobile"]); string Pwd = Com.Util.getStringByObject(Request.Form["password"]); try { if (Name == "" || Pwd == "" || Get_Authcode == "") { Response.Write("{\"status\":\"error\",\"content\":\"参数不能为空\"}"); } else { StringBuilder sqlStr = new StringBuilder(); //sqlStr.Append(string.Format("select top 1 MsCode from Bs_SMSCode where mobile='{0}' and DateDiff (minute,AddTime,'{1}')<=0 order by AddTime desc;", Name, DateTime.Now.AddMinutes(-20))); sqlStr.Append(string.Format("select id from Bs_User where mobile='{0}' and Bs_UserGradeCode='{1}'", Name, "01")); DataSet ds = CSA.DAL.DBAccess.getDS(sqlStr.ToString()); //DataTable dt1 = ds.Tables[0]; DataTable dt2 = ds.Tables[0]; //if (dt1.Rows.Count > 0 && Com.Util.getStringByObject(dt1.Rows[0]["MsCode"]) == Get_Authcode) //{ if (dt2.Rows.Count <= 0) { AutoNo ano = new AutoNo(); builder = new SQLBuilder("Bs_User"); builder.AddData("AddTime", DateTime.Now.ToString("s")); builder.AddData("code", "CC" + ano.autoNo()); builder.AddData("name", "User_" + ano.autoNo()); builder.AddData("levelname", "User_" + ano.GenerateRandom(2) + new Random().Next(0, 9999)); builder.AddData("pkid", CSA.Text.Util.getNewGuid()); builder.AddData("mobile", Name); builder.AddData("password", CSA.Security.Encrypt.getMD5(Pwd)); builder.AddData("Bs_UserGradeCode", "01"); builder.AddData("status", 1); if (builder.AutoInsert()) { //DBAccess.ExecuteNonQuery(string.Format("delete Bs_SMSCode where mobile='{0}'", Name)); Bs_User user = new Bs_User(); user.Mobile = Name; user.Password = Pwd; user.Bs_UserGradeCode = "01"; Factory.getUserBllInstance().login(user); if (CurInfo.CurUser != null) { Response.Write("{\"status\":\"success\",\"content\":\"注册成功\"}"); } else { Response.Write("{\"status\":\"error\",\"content\":\"获取用户信息失败!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"注册失败\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"该手机号码已被注册!\"}"); } //} //else // Response.Write("{\"status\":\"error\",\"content\":\"验证码错误或失效!\"}"); } } catch (Exception ex) { Response.Write("{\"status\":\"error\",\"content\":\"" + ex.ToString() + "\"}"); } break; #endregion #region ========= pwd 忘记密码 case "pwd": //忘记密码 Get_Authcode = Com.Util.getStringByObject(Request.Form["authcode"]).ToLower(); string p_Name = Com.Util.getStringByObject(Request.Form["username"]); string p_Pwd = Com.Util.getStringByObject(Request.Form["pwd"]); if (Session["msg_code"] != null) { if (Get_Authcode == Session["msg_code"].ToString()) { if (p_Name != "" && p_Pwd != "") { Bs_User user = new Bs_User(); string sql = "select * from Bs_User where Name='" + p_Name + "'"; dt = CSA.DAL.DBAccess.getRS(sql); if (dt.Rows.Count > 0) { Factory.getUserBllInstance().EditPwd(CSA.Security.Encrypt.getMD5(p_Pwd), Convert.ToInt32(dt.Rows[0]["ID"])); Factory.getUserBllInstance().logout(); //SendMsg(p_Name, "安全提示:您的密码在" + DateTime.Now + "时被修改,如非本人操作,请联系管理处。【实体店导购】"); Response.Write("{\"status\":\"success\",\"content\":\"修改成功,请使用新密码登陆!\"}"); } else { Response.Write("{\"status\":\"error\",\"content\":\"找不到该用户!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"读取信息失败!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"验证码错误!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"读取验证码失败!\"}"); } break; #endregion #region ========= editor_pwd 修改密码 case "editor_pwd": //修改密码 if (CurInfo.CurUser != null) { Get_Authcode = Com.Util.getStringByObject(Request.Form["authcode"]).ToLower(); string old_Pwd = Com.Util.getStringByObject(Request.Form["o_pwd"]); string new_Pwd = Com.Util.getStringByObject(Request.Form["n_pwd"]); if (Session[Common.HNKeys.SESSION_CODE] != null) { if (Get_Authcode == Session[Common.HNKeys.SESSION_CODE].ToString().ToLower()) { if (old_Pwd != "" && new_Pwd != "") { Bs_User user = new Bs_User(); string sql = "select id from Bs_User where id=" + CurInfo.CurUser.ID + " and Password='******'"; dt = CSA.DAL.DBAccess.getRS(sql); if (dt.Rows.Count > 0) { Factory.getUserBllInstance().EditPwd(CSA.Security.Encrypt.getMD5(new_Pwd), Convert.ToInt32(dt.Rows[0]["ID"])); Factory.getUserBllInstance().logout(); Response.Write("{\"status\":\"success\",\"content\":\"修改成功,请重新登陆!\"}"); } else { Response.Write("{\"status\":\"error\",\"content\":\"用户名或密码错误!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"读取信息失败!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"验证码错误!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"读取验证码失败!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"登陆信息已失效,请重新登陆!\"}"); } break; #endregion #region ========= editor_info 修改个人信息 case "editor_info": //修改个人信息 if (CurInfo.CurUser != null) { string info_name = Com.Util.getStringByObject(Request.Form["name"]); string info_sex = Com.Util.getStringByObject(Request.Form["sex"]); string info_email = Com.Util.getStringByObject(Request.Form["email"]); string info_address = Com.Util.getStringByObject(Request.Form["address"]); builder = new CSA.DAL.SQLBuilder("Bs_User"); builder.AddData("realname", info_name); builder.AddData("sex", info_sex); builder.AddData("email", info_email); builder.AddData("address", info_address); builder.Where = string.Format(" and {0}={1}", "id", CurInfo.CurUser.ID); if (builder.AutoUpdate()) { Bs_UserDao dao = new Bs_UserDao(); Bs_User user = dao.getUserByID(CurInfo.CurUser.ID); if (user != null) { CurInfo.CurUser = user; } Response.Write("{\"status\":\"success\",\"content\":\"修改个人信息成功!\"}"); } else { Response.Write("{\"status\":\"error\",\"content\":\"修改个人信息失败!\"}"); } } else { Response.Write("{\"status\":\"error\",\"content\":\"参数错误!\"}"); } break; #endregion } }
partial void SetEntityExpand(SQLBuilder sqlBuilder, BasePermissionEntity permissionEntity);
// 这个是声明扩展方法 partial void SetObjectExpand(SQLBuilder sqlBuilder, ZtoPrintCancelEntity entity);
// 这个是声明扩展方法 partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseModuleEntity baseModuleEntity);
/// <summary> /// 添加实体 /// </summary> /// <param name="workFlowActivityEntity">实体</param> public string AddEntity(BaseWorkFlowActivityEntity workFlowActivityEntity) { string sequence = string.Empty; if (workFlowActivityEntity.SortCode == null || workFlowActivityEntity.SortCode == 0) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); workFlowActivityEntity.SortCode = int.Parse(sequence); } SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, BaseWorkFlowActivityEntity.FieldId); if (!this.Identity) { sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldId, workFlowActivityEntity.Id); } else { if (!this.ReturnId && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2)) { if (DbHelper.CurrentDbType == DbTypes.Oracle) { sqlBuilder.SetFormula(BaseWorkFlowActivityEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DbHelper.CurrentDbType == DbTypes.DB2) { sqlBuilder.SetFormula(BaseWorkFlowActivityEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2)) { if (workFlowActivityEntity.Id == null) { if (string.IsNullOrEmpty(sequence)) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); } workFlowActivityEntity.Id = int.Parse(sequence); } sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldId, workFlowActivityEntity.Id); } } } this.SetEntity(sqlBuilder, workFlowActivityEntity); if (UserInfo != null) { sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldCreateUserId, UserInfo.Id); sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldCreateBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseWorkFlowActivityEntity.FieldCreateOn); if (UserInfo != null) { sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseWorkFlowActivityEntity.FieldModifiedOn); if (DbHelper.CurrentDbType == DbTypes.SqlServer && this.Identity) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
private void PopulateCrossTabulationViewControl(SQLBuilder.SelectQueryBuilder QuerryBuilder) { //display CrossTabulation header this.lblSummaryMainColumnName.Content = "Cross Tabulation by " + QuerryBuilder.CrossTabulationResults.CrossTabColumn.AliasName; // adding gropby column control int lineNumber = 0; List<List<string>> groupByColumnValues = QuerryBuilder.CrossTabulationResults.GroupByColumnValueList; int goupbyColumValueIndex = 0; for (int groupByColIndex = 0; groupByColIndex < QuerryBuilder.CrossTabulationResults.GroupByColumns.Count; groupByColIndex++) { SQLBuilder.Clauses.Column groupByCol = QuerryBuilder.CrossTabulationResults.GroupByColumns.ElementAt<SQLBuilder.Clauses.Column>(groupByColIndex); // find colum format string colFormat = SQLBuilder.Common.ColumnFormat.Instance.getColumnFormat(groupByCol.Format); CrossTabulationViewGroupByControl ctvgCntrl = new CrossTabulationViewGroupByControl(); ctvgCntrl.lblGroupByColumnHeader.Content = Common.getColumnNameOrAlias(groupByCol); for (int i = 0; i < groupByColumnValues.Count; i++) { Label colRow = new Label(); if ((lineNumber % 2) == 0) { colRow.Style = (Style)FindResource("CrossTabulationEvenGroupByColumRowStyle"); } else { colRow.Style = (Style)FindResource("CrossTabulationOddGroupByColumRowStyle"); } if (colFormat != null) { //formating group by col value colRow.Content = String.Format(colFormat, groupByColumnValues.ElementAt<List<string>>(i).ElementAt<string>(groupByColIndex)); } else { colRow.Content = groupByColumnValues.ElementAt<List<string>>(i).ElementAt<string>(groupByColIndex); } ctvgCntrl.StackPaenlGroupbyColumnRows.Children.Add(colRow); lineNumber = lineNumber + 1; } lineNumber = 0; this.StackPanelCrossTabulationViewGroupByControls.Children.Add(ctvgCntrl); goupbyColumValueIndex = goupbyColumValueIndex + 1; } lineNumber = 0; int groupByColCount = QuerryBuilder.CrossTabulationResults.GroupByColumns.Count; int summarrizeValueIndex = groupByColCount; // adding summary main control and summary column control // add Grand Total to CrossTabColumnVaues as las item Dictionary<string, Object> dataMap = QuerryBuilder.CrossTabulationResults.DataMap; QuerryBuilder.CrossTabulationResults.CrossTabColumnVaues.Add("Grand Total"); foreach (string summaryMainValue in QuerryBuilder.CrossTabulationResults.CrossTabColumnVaues) { CrossTabulationViewSummaryMainControl summaryMain = new CrossTabulationViewSummaryMainControl(); summaryMain.lblSummaryHeader.Content = summaryMainValue; for (int summaryColIndex = 0; summaryColIndex < QuerryBuilder.CrossTabulationResults.SummarizeColumns.Count; summaryColIndex++) { SQLBuilder.Clauses.Column summaryCol = QuerryBuilder.CrossTabulationResults.SummarizeColumns.ElementAt<SQLBuilder.Clauses.Column>(summaryColIndex); // find column format string summarycolFormat = SQLBuilder.Common.ColumnFormat.Instance.getColumnFormat(summaryCol.Format); CrossTabulationViewSummaryControl ctvsCtrl = new CrossTabulationViewSummaryControl(); ctvsCtrl.lblSummaryColumnHeader.Content = " " + Common.getColumnNameOrAlias(summaryCol) + " "; //chnageing background color for last grad total section if (summaryMainValue == "Grand Total") { summaryMain.lblSummaryHeader.Style = (Style)FindResource("CrossTabulationGrandTotalHeaderColumnStyle"); ctvsCtrl.lblSummaryColumnHeader.Style = (Style)FindResource("CrossTabulationGrandTotalHeaderColumnStyle"); } for (int keyIndex = 0; keyIndex < QuerryBuilder.CrossTabulationResults.KeyPrefixes.Count; keyIndex++) { string key = QuerryBuilder.CrossTabulationResults.KeyPrefixes.ElementAt<string>(keyIndex); Label colRow = new Label(); if ((lineNumber % 2) == 0) { if (summaryMainValue == "Grand Total") { colRow.Style = (Style)FindResource("CrossTabulationGrandTotalSummaryColumRowStyle"); } else { colRow.Style = (Style)FindResource("CrossTabulationEvenSummaryColumRowStyle"); } } else { colRow.Style = (Style)FindResource("CrossTabulationOddSummaryColumRowStyle"); } string keyValue = key + summaryMainValue + summaryColIndex; if (dataMap.ContainsKey(keyValue)) { if (summarycolFormat != null) { colRow.Content = String.Format(summarycolFormat, dataMap[keyValue]); } else { colRow.Content = dataMap[keyValue].ToString(); } } else { colRow.Content = ""; } DockPanel dp = new DockPanel(); dp.HorizontalAlignment = System.Windows.HorizontalAlignment.Stretch; dp.VerticalAlignment = System.Windows.VerticalAlignment.Stretch; dp.Children.Add(colRow); ctvsCtrl.StackPaenlSummaryColumnRows.Children.Add(dp); lineNumber = lineNumber + 1; } lineNumber = 0; summaryMain.StackPaenlSummaryMainColumns.Children.Add(ctvsCtrl); summarrizeValueIndex = summarrizeValueIndex + 1; } this.StackPanelCrossTabulationViewSummaryControls.Children.Add(summaryMain); } }
public ResultViewModel(SQLBuilder.SelectQueryBuilder QueryBuilder, string CurrentDatabaseName) { _getResultByQuery = true; _getResultByTreeView = false; _queryBuilder = QueryBuilder; _currentDatabaseName = CurrentDatabaseName; simpleCommand = new RelayCommand(new Action<object>(DoSimpleCommand)); RefreshResult(); }
private static void SetFieldDataType(SQLBuilder sqlb, string[] datatypes, Type t) { int u = datatypes.GetUpperBound(0); for (int i = 0; i <= u; i++) { Field field = null; if (t == typeof (FilterField)) { field = sqlb.FilterFields.Item(i); } if (t == typeof (DataField)) { field = sqlb.DataFields.Item(i); } field.DataType = datatypes[i]; } }
private void SetFilterFieldDataTypes(SQLBuilder sqlb, XSDAdapter xsda) { if (sqlb.FilterFields.Count > 0) { //SMELL : "fields" en "datatypes" //kunnen samengebracht worden in 1 nieuwe functie : //GetFilterFieldDatatypes //dat onmiddellijk string[] datatypes teruggeeft string[] fields = GetFilterFieldNames(sqlb); string[] datatypes = xsda.GetDataTypes(XsdName, fields); //end SMELL SetFilterFieldsDataType(sqlb, datatypes); } }
/// <summary> /// 添加实体 /// </summary> /// <param name="cASE_PRODUCTINFOEntity">实体</param> public string AddEntity(CASE_PRODUCTINFOEntity cASE_PRODUCTINFOEntity) { string sequence = string.Empty; this.Identity = false; if (cASE_PRODUCTINFOEntity.ID != null) { sequence = cASE_PRODUCTINFOEntity.ID; } SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, CASE_PRODUCTINFOTable.FieldID); if (!this.Identity) { if (string.IsNullOrEmpty(cASE_PRODUCTINFOEntity.ID)) { sequence = BusinessLogic.NewGuid(); cASE_PRODUCTINFOEntity.ID = sequence; } sqlBuilder.SetValue(CASE_PRODUCTINFOTable.FieldID, cASE_PRODUCTINFOEntity.ID); } else { if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2)) { if (DBProvider.CurrentDbType == CurrentDbType.Oracle) { sqlBuilder.SetFormula(CASE_PRODUCTINFOTable.FieldID, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DBProvider.CurrentDbType == CurrentDbType.DB2) { sqlBuilder.SetFormula(CASE_PRODUCTINFOTable.FieldID, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2)) { if (string.IsNullOrEmpty(cASE_PRODUCTINFOEntity.ID)) { if (string.IsNullOrEmpty(sequence)) { CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); } cASE_PRODUCTINFOEntity.ID = sequence; } sqlBuilder.SetValue(CASE_PRODUCTINFOTable.FieldID, cASE_PRODUCTINFOEntity.ID); } } } this.SetEntity(sqlBuilder, cASE_PRODUCTINFOEntity); if (UserInfo != null) { sqlBuilder.SetValue(CASE_PRODUCTINFOTable.FieldCREATEUSERID, UserInfo.Id); sqlBuilder.SetValue(CASE_PRODUCTINFOTable.FieldCREATEBY, UserInfo.RealName); } sqlBuilder.SetDBNow(CASE_PRODUCTINFOTable.FieldCREATEON); if (UserInfo != null) { sqlBuilder.SetValue(CASE_PRODUCTINFOTable.FieldMODIFIEDUSERID, UserInfo.Id); sqlBuilder.SetValue(CASE_PRODUCTINFOTable.FieldMODIFIEDBY, UserInfo.RealName); } sqlBuilder.SetDBNow(CASE_PRODUCTINFOTable.FieldMODIFIEDON); if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access)) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
private static bool MustSetDataFieldDataTypes(SQLBuilder sqlb) { return sqlb.SQLtype != snpSQLtype.sqlSelect && sqlb.SQLtype != snpSQLtype.sqlDelete; }
internal PivotServiceApi(DBConnector db, IMemoryCache memoryCache) { Db = db; _memoryCache = memoryCache; queryBuilder = new SQLBuilder(); }
private static string[] GetFilterFieldDataTypes(SQLBuilder sqlb, XSDAdapter xsda) { string[] fields = GetFilterFieldNames(sqlb); return xsda.GetDataTypes(XsdName, fields); }
private void webServerProc() { // 管理者権限がない場合は起動しない if (!WindowsUtils.IsExecuteAdminRole()) { MessageUtils.showMessage(MessageBoxIcon.Warning, MessageResource.W0005); return; } listener = new HttpListener(); listener.Prefixes.Add(prefix); // プレフィックスの登録 try { listener.Start(); } catch (HttpListenerException httpListenerException) { // すでにポートが使用中もしくは管理者権限なし LinearAudioPlayer.writeErrorMessage(httpListenerException); return; } while (true) { HttpListenerContext context = null; try { context = listener.GetContext(); } catch (HttpListenerException) { // HTTP通信中に終了されたらどうしようもないので例外を握りつぶす } HttpListenerRequest req = context.Request; HttpListenerResponse res = context.Response; Debug.WriteLine("request url: " + req.RawUrl); if (req.RawUrl.IndexOf("/LinearWebService") == -1) { // WEBサーバ string reqPath = req.RawUrl; if (reqPath == "/") { reqPath = "ui/" + LinearGlobal.LinearConfig.ViewConfig.WebInterfaceTheme + ".html"; } reqPath = reqPath.Replace("/", "\\"); reqPath = Regex.Replace(reqPath, "\\?.*", ""); // リクエストされたURLからファイルのパスを求める string path = docRoot + reqPath; // ファイルが存在すればレスポンス・ストリームに書き出す if (File.Exists(path)) { byte[] content = File.ReadAllBytes(path); //string s = File.ReadAllText(path, Encoding.UTF8); //byte[] content = Encoding.UTF8.GetBytes(s); res.Headers[HttpResponseHeader.ContentType] = GuessContentType(Path.GetExtension(path)); res.OutputStream.Write(content, 0, content.Length); } } else { // RESTサービス // TODO:変なもの受け取ったら落ちる WebServiceResponseInfo response = new WebServiceResponseInfo(); var dict = req.QueryString; var reqParamJsonString = JsonConvert.SerializeObject( dict.AllKeys.ToDictionary(k => k, k => dict[k]) ); Debug.WriteLine("req data: " + reqParamJsonString); WebServiceRequestInfo request = JsonConvert.DeserializeObject <WebServiceRequestInfo>(reqParamJsonString); response.action = request.action; switch (request.action) { case "play": Action playAction = () => { LinearAudioPlayer.PlayController.play(LinearGlobal.CurrentPlayItemInfo.Id, false, false); }; LinearGlobal.MainForm.BeginInvoke(playAction); break; case "pause": Action pauseAction = () => { LinearAudioPlayer.PlayController.pause(); }; LinearGlobal.MainForm.BeginInvoke(pauseAction); break; case "stop": Action stopAction = () => { LinearAudioPlayer.PlayController.stop(); }; LinearGlobal.MainForm.BeginInvoke(stopAction); break; case "previous": Action previouspAction = () => { LinearAudioPlayer.PlayController.previousPlay(); }; LinearGlobal.MainForm.BeginInvoke(previouspAction); break; case "forward": Action forwardAction = () => { if (LinearAudioPlayer.PlayController.isPlaying()) { LinearAudioPlayer.PlayController.endOfStream(); } }; LinearGlobal.MainForm.BeginInvoke(forwardAction); break; case "voldown": Action volDownAction = () => { int vol = LinearGlobal.Volume; vol -= 5; if (vol < 0) { vol = 0; } LinearGlobal.Volume = vol; LinearGlobal.MainForm.ListForm.setVolume(); }; var voldownActionResult = LinearGlobal.MainForm.BeginInvoke(volDownAction); voldownActionResult.AsyncWaitHandle.WaitOne(); response.volume = LinearGlobal.Volume; break; case "volup": Action volUpAction = () => { int vol = LinearGlobal.Volume; vol += 5; if (vol > 100) { vol = 100; } LinearGlobal.Volume = vol; LinearGlobal.MainForm.ListForm.setVolume(); }; var volupActionResult = LinearGlobal.MainForm.BeginInvoke(volUpAction); volupActionResult.AsyncWaitHandle.WaitOne(); response.volume = LinearGlobal.Volume; break; case "getplayinfo": if (LinearAudioPlayer.PlayController != null) { response.playInfo = LinearGlobal.CurrentPlayItemInfo; response.isPlaying = LinearAudioPlayer.PlayController.isPlaying(); response.isPaused = LinearAudioPlayer.PlayController.isPaused(); response.seekRatio = (int)(((float)LinearAudioPlayer.PlayController.getPosition() / (float)LinearAudioPlayer.PlayController.getLength()) * 100); if (response.seekRatio == 100) { response.seekRatio = 0; } } break; case "seek": Action seekAction = () => { double value = ((double)LinearAudioPlayer.PlayController.getLength()) * request.seekPosition; LinearAudioPlayer.PlayController.setPosition((uint)value); }; LinearGlobal.MainForm.ListForm.BeginInvoke(seekAction); break; case "getthemelist": var themelist = new List <string>(); var filePaths = FileUtils.getFilePathList( Application.StartupPath + LinearConst.WEB_DIRECTORY_NAME + "ui", SearchOption.TopDirectoryOnly); foreach (string path in filePaths) { themelist.Add(Path.GetFileNameWithoutExtension(path)); } response.themeList = themelist.ToArray().Reverse().ToArray(); response.nowThemeName = LinearGlobal.LinearConfig.ViewConfig.WebInterfaceTheme; break; case "switchtheme": LinearGlobal.LinearConfig.ViewConfig.WebInterfaceTheme = request.theme; break; case "getnowplaying": response.nowPlaying = LinearAudioPlayer.PlayController.getNowPlayingList(10).Select(gi => new TrackInfo(gi.Id, gi.Title, gi.Artist, gi.Rating)).ToArray(); break; case "addnowplaying": response.nowPlaying = LinearAudioPlayer.PlayController.getNowPlayingList(request.skip, request.take).Select(gi => new TrackInfo(gi.Id, gi.Title, gi.Artist, gi.Rating)).ToArray(); break; case "getanalyzeinfo": var ai = new AnalyzeInfo(); var startDate = SQLiteManager.Instance.executeQueryOnlyOne(SQLResource.SQL056); if (startDate != null) { ai.StartDate = startDate.ToString().Substring(0, 10); ai.StartDateRelative = DateTimeUtils.getRelativeTimeString(startDate.ToString()); } ai.TotalTracksCount = (long)SQLiteManager.Instance.executeQueryOnlyOne(SQLResource.SQL057); ai.TotalFavoriteTracksCount = (long)SQLiteManager.Instance.executeQueryOnlyOne(SQLResource.SQL058); ai.TotalPlayCount = (long)SQLiteManager.Instance.executeQueryOnlyOne(SQLResource.SQL059); ai.TotalPalyHistoryCount = (long)SQLiteManager.Instance.executeQueryOnlyOne(SQLResource.SQL060); response.analyzeOverview = ai; break; case "getrecentlist": var paramList = new List <DbParameter>(); var recentlist = new List <TrackInfo>(); var limit = request.limit; if (LinearGlobal.CurrentPlayItemInfo != null && request.offset == 0) { var ci = LinearGlobal.CurrentPlayItemInfo; recentlist.Add(new TrackInfo(ci.Id, ci.Title, ci.Artist, "", "", ci.Rating)); // NowPlaying limit--; } paramList.Add(new SQLiteParameter("Limit", limit)); paramList.Add(new SQLiteParameter("Offset", request.offset)); recentlist.AddRange(SQLiteManager.Instance.executeQueryNormal(SQLResource.SQL061, paramList).Select(o => new TrackInfo((long)o[0], o[1].ToString(), o[2].ToString(), o[3].ToString(), o[4].ToString(), int.Parse(o[5].ToString())))); response.recentListen = recentlist.ToArray(); var offset = request.offset - limit < 0 ? 0 : request.offset - limit; response.pagerPrevious = request.offset == 0 ? -1 : offset; response.pagerNext = response.recentListen.Length < limit ? -1 : request.offset + limit; break; case "gettopartist": var sql = SQLResource.SQL062; var rangeType = (RangeType)Enum.Parse(typeof(RangeType), request.rangeType); var where = ""; if (rangeType != RangeType.ALL) { where = string.Format( "WHERE PH.PLAYDATETIME >= DATETIME(DATETIME('NOW','LOCALTIME'), '{0}','LOCALTIME')", _rangeDictionary[rangeType]); } else { sql = SQLResource.SQL064; } sql = sql.Replace(":Condition", where); var topArtists = SQLiteManager.Instance.executeQueryNormal(sql, new SQLiteParameter("Limit", request.limit)); if (topArtists.Length > 0) { double maxcount = topArtists.Max(o => (long)o[1]); response.topLists = topArtists.Select( o => new TrackInfo(o[0].ToString(), (long)o[1], (int)((int.Parse(o[1].ToString()) / maxcount) * 100), o[2].ToString())) .ToArray(); } break; case "gettoptrack": var sql2 = SQLResource.SQL063; var rangeType2 = (RangeType)Enum.Parse(typeof(RangeType), request.rangeType); var where2 = ""; if (rangeType2 != RangeType.ALL) { where2 = string.Format( "WHERE PH.PLAYDATETIME >= DATETIME(DATETIME('NOW','LOCALTIME'), '{0}','LOCALTIME')", _rangeDictionary[rangeType2]); } else { sql2 = SQLResource.SQL065; } sql2 = sql2.Replace(":Condition", where2); var topTracks = SQLiteManager.Instance.executeQueryNormal(sql2, new SQLiteParameter("Limit", request.limit)); if (topTracks.Length > 0) { double maxcount2 = topTracks.Max(o => (long)o[2]); response.topLists = topTracks.Select( o => new TrackInfo(o[0].ToString() + " - " + o[1].ToString(), (long)o[2], (int)((int.Parse(o[2].ToString()) / maxcount2) * 100), o[3].ToString(), int.Parse(o[4].ToString()))).ToArray(); } break; case "ratingon": case "ratingoff": if (request.id == -1) { break; } LinearEnum.RatingValue rating = request.action == "ratingon" ? LinearEnum.RatingValue.FAVORITE : LinearEnum.RatingValue.NORMAL; Action setRatingAction = () => { var rowIndex = LinearAudioPlayer.GridController.Find((int)GridController.EnuGrid.ID, request.id.ToString()); if (rowIndex != -1) { LinearAudioPlayer.GridController.setRatingIcon(rowIndex, rating); } if (request.id == LinearGlobal.CurrentPlayItemInfo.Id) { LinearGlobal.MainForm.setRating((int)rating); } }; LinearGlobal.MainForm.ListForm.BeginInvoke(setRatingAction); SQLiteManager.Instance.executeNonQuery( SQLBuilder.updateRating( request.id, rating)); break; case "skipnowplaying": Action skipNowPlayingAction = () => { LinearAudioPlayer.PlayController.skipPlayingList(request.id); LinearAudioPlayer.PlayController.play(request.id, false, true); }; LinearGlobal.MainForm.BeginInvoke(skipNowPlayingAction); break; case "getartwork": if (LinearGlobal.CurrentPlayItemInfo.Artwork != null) { try { if (request.artworkSize == 0) { request.artworkSize = 150; } Bitmap thumbnail = new Bitmap(request.artworkSize, request.artworkSize); using (Graphics g = Graphics.FromImage(thumbnail)) { g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic; g.DrawImage(LinearGlobal.CurrentPlayItemInfo.Artwork, 0, 0, request.artworkSize, request.artworkSize); } var artworkDirectoy = Application.StartupPath + Path.Combine(Path.Combine(LinearConst.WEB_DIRECTORY_NAME, "img"), "artwork"); Directory.CreateDirectory(artworkDirectoy); var artworkFileName = string.Format("{0}.png", LinearGlobal.CurrentPlayItemInfo.Id); var artworkThumbFileName = string.Format("{0}-thumb.png", LinearGlobal.CurrentPlayItemInfo.Id); LinearGlobal.CurrentPlayItemInfo.Artwork.Save(artworkDirectoy + "\\" + artworkFileName, System.Drawing.Imaging.ImageFormat.Png); thumbnail.Save(artworkDirectoy + "\\" + artworkThumbFileName, System.Drawing.Imaging.ImageFormat.Png); thumbnail.Dispose(); var oldfiles = Directory.GetFiles(artworkDirectoy, "*.png") .Where(a => Path.GetFileName(a).IndexOf(LinearGlobal.CurrentPlayItemInfo.Id.ToString()) == -1); foreach (var file in oldfiles) { File.Delete(file); } response.artworkUrl = "../img/artwork/" + artworkFileName; response.artworkThumbUrl = "../img/artwork/" + artworkThumbFileName; } catch (Exception) { response.artworkUrl = ""; } } else { response.artworkUrl = ""; } break; } string resJsonString = JsonConvert.SerializeObject(response); byte[] responseByte = Encoding.UTF8.GetBytes(resJsonString); res.OutputStream.Write(responseByte, 0, responseByte.Length); } res.Close(); } }
public ReportEntity LoadReport(int id) { SQLBuilder sb = new SQLBuilder(@"Select r.Id as ReportId, r.Title as Title, r.LastUpdated, rs.Description as ReportStatus FROM Report r inner join ReportStatus rs on r.ReportStatusId = rs.Id WHERE r.Id=" + id); DataTable dt = DB.GetDataTable(sb); return (dt.Rows.Count != 0) ? PopulateReportEntityDomain(dt.Rows[0], null) : null; }
/// <summary> /// 保存修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSvEdit_Click(object sender, EventArgs e) { string idList = ""; try { CSA.DAL.SQLBuilder builder = new SQLBuilder(); builder.TblName = TblName; builder.AutoSetInfo(divDtls); builder.AddData("pic", focus_photo.Value); builder.Where = string.Format(" and {0}='{1}'", PKField, PKID.Value); builder.setModUserInfo(BLL.User.AdminUser.UserID); List <string> lst = new List <string>(); lst.Add(builder.UpdateSql); #region 保存相册========== string[] albumArr = Request.Form.GetValues("hide_photo_name"); string[] remarkArr = Request.Form.GetValues("hide_photo_remark"); if (albumArr != null && albumArr.Length > 0) { for (int i = 0; i < albumArr.Length; i++) { string[] imgArr = albumArr[i].Split('|'); int img_id = int.Parse(imgArr[0]); idList += img_id + ","; if (imgArr.Length == 3) { string remark = ""; if (!string.IsNullOrEmpty(remarkArr[i])) { remark = remarkArr[i]; } //图片id存在---修改 否则 添加 if (img_id > 0) { string sql = string.Format("update Bs_NewsAlbums set new_pkid='{0}',big_img='{1}',small_img='{2}',remark='{3}' where id={4}", this.PKID.Value, imgArr[1], imgArr[2], remark, img_id); lst.Add(sql); } else { string sql = string.Format("insert into Bs_NewsAlbums(new_pkid,big_img,small_img,remark,type) values ('{0}','{1}','{2}','{3}','product')", this.PKID.Value, imgArr[1], imgArr[2], remark); lst.Add(sql); } } } } //删除已删除的图片 new Bs_NewsAlbumsDao().DeleteList(idList, PKID.Value); #endregion if (CSA.DAL.DBAccess.ExecuteSqlTran(lst) > 0) { BLL.Sys.AdminLog.AddLog(Request.QueryString["mid"], Header.Title, TblName, PKID.Value, "修改", ControlHelper.getControlContent(divDtls, null)); //JscriptMsg("修改操作成功!", "", "Success"); Response.Write("<script language='javascript'>alert('修改操作成功');location.href='" + Request.Url.ToString() + "'</script>"); } else { Response.Write("<script language='javascript'>alert('修改操作失败');location.href='" + Request.Url.ToString() + "'</script>"); //JscriptMsg("修改操作失败!", "", "Error"); } } catch (Exception ex) { JscriptMsg("修改失败!" + ex.Message.Replace("\r\n", ""), "", "Error"); } }
/// <summary> /// 设置实体 /// </summary> /// <param name="sqlBuilder">SQL生成器</param> /// <param name="myAdviceEntity">实体对象</param> private void SetEntity(SQLBuilder sqlBuilder, BaseAdviceEntity myAdviceEntity) { sqlBuilder.SetValue(BaseAdviceTable.FieldTitle, myAdviceEntity.Title); sqlBuilder.SetValue(BaseAdviceTable.FieldContent, myAdviceEntity.Content); sqlBuilder.SetValue(BaseAdviceTable.FieldPhone, myAdviceEntity.Phone); sqlBuilder.SetValue(BaseAdviceTable.FieldEmail, myAdviceEntity.Email); sqlBuilder.SetValue(BaseAdviceTable.FieldOICQ, myAdviceEntity.OICQ); sqlBuilder.SetValue(BaseAdviceTable.FieldMSN, myAdviceEntity.MSN); sqlBuilder.SetValue(BaseAdviceTable.FieldIPAddress, myAdviceEntity.IPAddress); sqlBuilder.SetValue(BaseAdviceTable.FieldPublicState, myAdviceEntity.PublicState); sqlBuilder.SetValue(BaseAdviceTable.FieldPriorityID, myAdviceEntity.PriorityID); sqlBuilder.SetValue(BaseAdviceTable.FieldDisposeStateID, myAdviceEntity.DisposeStateID); sqlBuilder.SetValue(BaseAdviceTable.FieldSendTo, myAdviceEntity.SendTo); sqlBuilder.SetValue(BaseAdviceTable.FieldSortCode, myAdviceEntity.SortCode); sqlBuilder.SetValue(BaseAdviceTable.FieldDescription, myAdviceEntity.Description); sqlBuilder.SetValue(BaseAdviceTable.FieldEnabled, myAdviceEntity.Enabled); }
/// <summary> /// 添加实体 /// </summary> /// <param name="baseContactDetailsEntity">实体</param> public string AddEntity(BaseContactDetailsEntity baseContactDetailsEntity) { string sequence = string.Empty; sequence = baseContactDetailsEntity.Id; if (baseContactDetailsEntity.SortCode == 0) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); baseContactDetailsEntity.SortCode = int.Parse(sequence); } SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(BaseContactDetailsEntity.TableName, BaseContactDetailsEntity.FieldId); if (baseContactDetailsEntity.Id is string) { this.Identity = false; } if (!this.Identity) { sqlBuilder.SetValue(BaseContactDetailsEntity.FieldId, baseContactDetailsEntity.Id); } else { if (!this.ReturnId && DbHelper.CurrentDbType == DbTypes.Oracle) { sqlBuilder.SetFormula(BaseContactDetailsEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } else { if (this.Identity && DbHelper.CurrentDbType == DbTypes.Oracle) { if (string.IsNullOrEmpty(sequence)) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); } baseContactDetailsEntity.Id = sequence; sqlBuilder.SetValue(BaseContactDetailsEntity.FieldId, baseContactDetailsEntity.Id); } } } this.SetEntity(sqlBuilder, baseContactDetailsEntity); if (UserInfo != null) { sqlBuilder.SetValue(BaseContactDetailsEntity.FieldCreateUserId, UserInfo.Id); sqlBuilder.SetValue(BaseContactDetailsEntity.FieldCreateBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseContactDetailsEntity.FieldCreateOn); if (UserInfo != null) { sqlBuilder.SetValue(BaseContactDetailsEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseContactDetailsEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseContactDetailsEntity.FieldModifiedOn); if (DbHelper.CurrentDbType == DbTypes.SqlServer && this.Identity) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { switch (Request["action"]) { case "save": //设置权限 try { string pkids = Request["para1"]; //role ids pkid = Request["pkid"]; //delete old RoleMnu set sqlList.Add(string.Format("DELETE FROM Sy_RoleMnu WHERE Sy_RoleFK = '{0}'", pkid)); //insert new RoleMnu SQLBuilder builder = new SQLBuilder(TblName); pkids = pkids.Replace("root", ""); foreach (string _pkid in pkids.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries)) { builder.Clear(); builder.TblName = TblName; builder.AddData("ModUser", BLL.User.AdminUser.UserID); builder.AddData("ModTime", DateTime.Now.ToString()); builder.AddData("Sy_RoleFK", pkid); builder.AddData("Sy_MenuFK", _pkid.Trim()); sqlList.Add(builder.InsertSql); } DBAccess.ExecuteSqlTran(sqlList); msg = "权限已成功更新到服务器!"; } catch (Exception ex) { msg = "保存到服务器时出现错误!" + ex.Message; } finally { sqlList = null; } break; default: //读取菜单 string node = Request["node"]; //id pkid = Request["pkid"]; type = Request["type"]; // 分类,root string chk = Request["chk"]; string role = Request["role"]; //过滤node不是PKID时 if (node.Equals(type)) { node = ""; } if ("1".Equals(chk)) { ChkBoxParas = "cls: 'folder',checked:false,"; } else { ChkBoxParas = ""; } msg = getSyMenu(node.Replace("root", ""), role); break; } Response.Write(msg);//Comm.getMsgForJson(pkids)); Response.End(); } } catch (Exception ex) { // WriteEnd("初始数据出错!" + ex.Message); } }
partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseRoleEntity roleEntity);
partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseOrganizeEntity organizeEntity);
private static void SetDataFieldDataTypes(SQLBuilder sqlb, XSDAdapter xsda) { if (MustSetDataFieldDataTypes(sqlb)) { string[] datatypes = GetDataFieldDataTypes(sqlb, xsda); SetFieldDataType(sqlb, datatypes, typeof (DataField)); } }