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