/// <summary>
/// 新增
/// </summary>
/// <param name="data"></param>
/// <returns>返回新增ID</returns>
public virtual string add(System.Collections.Hashtable data)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = this.extendSql(this.SqlText, data);
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
if (this.Result)
{
return ds.Tables[0].Rows[0][0].ToString();
}
else
{
return strSql;
}
}
public DataSet Login(string name, string password)
{
password = CommonLib.Common.Function.toMD5String(password);
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = "SELECT sy_users.*, UserTypeText FROM sy_users LEFT JOIN sy_usertype ON sy_users.UserTypeID = sy_usertype.UserTypeID WHERE Name = '@Name@';";
strSql = strSql.Replace("@Name@", name);
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
if (!DatabaseLib.Tools.tableIsNull(ds))
{
return null;
}
else
{
return ds;
}
}
public void GetSystemDataClient()
{
_dataClient = null;
DatabaseLib.DatabaseFactory databaseFactory = new DatabaseLib.DatabaseFactory();
_dataClient = databaseFactory.CreateClient(BaseLib.SystemType.Web);
}
public void Delete(CodeEntity codeEntity)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = "DELETE FROM s_codes WHERE ID = '@ID@'";
strSql = strSql.Replace("@ID@", codeEntity.ID);
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
}
public virtual void delete(string id)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
DatabaseLib.Tools tools = new DatabaseLib.Tools();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = this.SqlText + id;
strSql = tools.fixSqlText(strSql);
dataClient.SqlText = strSql;
dataClient.Execute(CommandType.Text);
this.Message = dataClient.Message;
this.Result = dataClient.Result;
}
public void Add(CodeEntity codeEntity)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = "INSERT INTO s_codes(ID, Text, Value, Code, CodeText) VALUES('@ID@', '@Text@', '@Value@', '@Code@', '@CodeText@')";
strSql = strSql.Replace("@ID@", codeEntity.ID);
strSql = strSql.Replace("@Text@", codeEntity.Text);
strSql = strSql.Replace("@Value@", codeEntity.Value);
strSql = strSql.Replace("@Code@", codeEntity.Code);
strSql = strSql.Replace("@CodeText@", codeEntity.CodeText);
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
}
/// <summary>
/// 获取顶级菜单
/// </summary>
/// <returns></returns>
public List<System.Collections.Hashtable> getTopMenu()
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
dataClient.SqlText = "SELECT * FROM sy_menus WHERE Level = 1";
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
List<System.Collections.Hashtable> list = null;
if (this.Result)
{
list = new List<System.Collections.Hashtable>();
foreach (DataRow row in ds.Tables[0].Rows)
{
System.Collections.Hashtable ht = new System.Collections.Hashtable();
foreach (DataColumn dc in ds.Tables[0].Columns)
{
string key = dc.ColumnName;
string value = CommonLib.Common.Validate.IsNullString(row[dc.ColumnName]);
ht.Add(key, value);
}
list.Add(ht);
}
return list;
}
else
return null;
}
public DataTable LoadData(KernelLib.SystemEntity.ModuleEntity module, KernelLib.SystemEntity.ProjectEntity project)
{
DataFrameLib.ScriptFactory scriptFactory = new DataFrameLib.ScriptFactory();
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
//获取脚本生成对象
DataFrameLib.iScript script = scriptFactory.CreateClient(project);
//生成执行脚本
string strScript = script.GetLoadScript(module.Entity, project);
dataClient.SqlText = strScript;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
if (this.Result)
return ds.Tables[0];
else
return null;
}
/// <summary>
/// 获取当前流水号的num
/// </summary>
/// <param name="pix">流水号前缀</param>
/// <param name="date">获取流水号的日期</param>
/// <returns>返回流水号</returns>
public string getSerialNumber(string pix, string date)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = "UPDATE sy_serialnumber set Num = 0, `Date` = '@Date@' where Pix = '@Pix@' and `Date` != '@Date@'; update sy_serialnumber set num = num + 1 where Pix = '@Pix@' and `Date`= '@Date@'; select num from sy_serialnumber where pix = '@Pix@'";
strSql = strSql.Replace("@Pix@", pix);
strSql = strSql.Replace("@Date@", date);
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
if (this.Result)
{
if (!DatabaseLib.Tools.tableIsNull(ds))
{
return null;
}
///设置流水号流水部分为6位, 根据所得流水值的长度补充位数"0"
string serial_num = ds.Tables[0].Rows[0][0].ToString();
string tmp = "00000";
serial_num = tmp.Substring(0, tmp.Length - serial_num.Length) + serial_num;
return date.Replace("-", "") + serial_num;
}
else
return null;
}
public void Init()
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = "SELECT * FROM s_codes";
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
if (this.Result)
{
this._Codes = ds.Tables[0];
}
}
public void Modify(CodeEntity codeEntity)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = "UPDATE s_codes SET Text = '@Text@', Value = '@Value@' WHERE ID = '@ID@'; UPDATE s_codes SET CodeText = '@CodeText@ WHERE Code = '@Code@'";
strSql = strSql.Replace("@ID@", codeEntity.ID);
strSql = strSql.Replace("@Text@", codeEntity.Text);
strSql = strSql.Replace("@Value@", codeEntity.Value);
strSql = strSql.Replace("@Code@", codeEntity.Code);
strSql = strSql.Replace("@CodeText@", codeEntity.CodeText);
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
}
/// <summary>
/// 保存信息
/// </summary>
/// <param name="id"></param>
/// <param name="data"></param>
public virtual void save(System.Collections.Hashtable data)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = this.extendSql(this.SqlText, data);
dataClient.SqlText = strSql;
dataClient.Execute(CommandType.Text);
this.Message = dataClient.Message;
this.Result = dataClient.Result;
}
public virtual List<System.Collections.Hashtable> Query(string strSql)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
List<System.Collections.Hashtable> list = new List<System.Collections.Hashtable>();
if (this.Result)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
System.Collections.Hashtable ht = new System.Collections.Hashtable();
foreach (DataColumn dc in ds.Tables[0].Columns)
{
string key = dc.ColumnName;
string value = row[dc.ColumnName].ToString();
ht.Add(key, value);
}
list.Add(ht);
}
return list;
}
else
return null;
}
public virtual System.Collections.Hashtable load(string id)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = this.SqlText + id;
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
if (this.Result)
{
if (!DatabaseLib.Tools.tableIsNull(ds))
{
return null;
}
System.Collections.Hashtable item = new System.Collections.Hashtable();
foreach (DataColumn dc in ds.Tables[0].Columns)
{
string key = dc.ColumnName;
string value = CommonLib.Common.Validate.IsNullString(ds.Tables[0].Rows[0][dc.ColumnName]);
item.Add(key, value);
}
return item;
}
else
{
return null;
}
}
// 返回用户对应的角色， 在实际中， 可以从SQL数据库中读取用户的角色信息
private string GetRole(string name)
{
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
string strSql = "SELECT UserTypeText FROM sy_users LEFT JOIN sy_usertype ON sy_users.UserTypeID = sy_usertype.UserTypeID WHERE Name = '@Name@';";
strSql = strSql.Replace("@Name@", name);
dataClient.SqlText = strSql;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
if (!DatabaseLib.Tools.tableIsNull(ds))
{
return "none";
}
else
{
return ds.Tables[0].Rows[0]["UserTypeText"].ToString();
}
}
