/// <summary>
/// 返回映射中的指定字段名称值
/// </summary>
/// <param name="hepler"></param>
/// <param name="itype"></param>
/// <param name="ReturnKey"></param>
/// <returns></returns>
public static string Comm_Map_Name(this HtmlHelper hepler, string ModuleCode, string itype, string ReturnKey)
{
string name = "";
Sys_Map model = new Sys_Map();
if (!string.IsNullOrEmpty(itype))
{
//开启Session缓存映射数据
//if (SessionConfig.GetSession("ITYPE") == null)
//{
ADOSys_Map MapInstance = new ADOSys_Map();
var result = MapInstance.GetAll();
SessionConfig.SetSession("ITYPE", result);
//}
List<Sys_Map> list = (List<Sys_Map>)SessionConfig.GetSession("ITYPE");
PropertyDescriptorCollection pList = TypeDescriptor.GetProperties(typeof(Sys_Map));
var filterList = list.Where(o => o.Map_Source == itype
&& o.Map_Module == ModuleCode);
if (list != null && filterList != null && filterList.Count() > 0)
{
model = filterList.FirstOrDefault();
name = pList[ReturnKey] != null ? pList[ReturnKey].GetValue(model).ToString() : "";
}
}
return name;
}
public bool AddMap(Sys_Map map)
{
if (mapInstance.Add(map) > 0)
{
return true;
}
return false;
}
public bool DeleteMap(Sys_Map map)
{
map.Stat = 1;
if (mapInstance.Update(map) > 0)
{
return true;
}
return false;
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Sys_Map GetModel(string strCondition)
{
List<Sys_Map> list = instance.GetListByWhere(strCondition);
Sys_Map model = new Sys_Map();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
/// <summary>
/// 通用映射获取
/// </summary>
/// <param name="source"></param>
/// <returns></returns>
public Sys_Map CommMap(string ModuleName, string source)
{
Sys_Map model = new Sys_Map();
List<Sys_Map> list = MapInstance.GetListByWhere(" AND Map_Module='" + ModuleName + "' AND Map_Source='" + source + "' ");
if (list.Count > 0)
{
model = list[0];
}
return model;
}
public bool UpdateMap(Sys_Map map)
{
if (mapInstance.Update(map) > 0)
{
return true;
}
return false;
}
/// <summary>
/// 更新Sys_Map对象(即:一条记录
/// </summary>
public int Update(Sys_Map sys_Map)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE Sys_Map SET ");
if(sys_Map.Map_Module_IsChanged){sbParameter.Append("Map_Module=@Map_Module, ");}
if(sys_Map.Map_Source_IsChanged){sbParameter.Append("Map_Source=@Map_Source, ");}
if(sys_Map.Map_Object_IsChanged){sbParameter.Append("Map_Object=@Map_Object, ");}
if(sys_Map.Map_Object1_IsChanged){sbParameter.Append("Map_Object1=@Map_Object1, ");}
if(sys_Map.Map_Object2_IsChanged){sbParameter.Append("Map_Object2=@Map_Object2, ");}
if(sys_Map.Map_Type_IsChanged){sbParameter.Append("Map_Type=@Map_Type, ");}
if(sys_Map.Map_UDEF1_IsChanged){sbParameter.Append("Map_UDEF1=@Map_UDEF1, ");}
if(sys_Map.Map_UDEF2_IsChanged){sbParameter.Append("Map_UDEF2=@Map_UDEF2, ");}
if(sys_Map.Map_UDEF3_IsChanged){sbParameter.Append("Map_UDEF3=@Map_UDEF3, ");}
if(sys_Map.Map_UDEF4_IsChanged){sbParameter.Append("Map_UDEF4=@Map_UDEF4, ");}
if(sys_Map.Map_UDEF5_IsChanged){sbParameter.Append("Map_UDEF5=@Map_UDEF5, ");}
if(sys_Map.Stat_IsChanged){sbParameter.Append("Stat=@Stat ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Map_ID=@Map_ID; " );
string sql=sb.ToString();
if(sys_Map.Map_Module_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_Module))
{
idb.AddParameter("@Map_Module", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Module", sys_Map.Map_Module);
}
}
if(sys_Map.Map_Source_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_Source))
{
idb.AddParameter("@Map_Source", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Source", sys_Map.Map_Source);
}
}
if(sys_Map.Map_Object_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_Object))
{
idb.AddParameter("@Map_Object", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Object", sys_Map.Map_Object);
}
}
if(sys_Map.Map_Object1_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_Object1))
{
idb.AddParameter("@Map_Object1", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Object1", sys_Map.Map_Object1);
}
}
if(sys_Map.Map_Object2_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_Object2))
{
idb.AddParameter("@Map_Object2", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Object2", sys_Map.Map_Object2);
}
}
if(sys_Map.Map_Type_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_Type))
{
idb.AddParameter("@Map_Type", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Type", sys_Map.Map_Type);
}
}
if(sys_Map.Map_UDEF1_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_UDEF1))
{
idb.AddParameter("@Map_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF1", sys_Map.Map_UDEF1);
}
}
if(sys_Map.Map_UDEF2_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_UDEF2))
{
idb.AddParameter("@Map_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF2", sys_Map.Map_UDEF2);
}
}
if(sys_Map.Map_UDEF3_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_UDEF3))
{
idb.AddParameter("@Map_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF3", sys_Map.Map_UDEF3);
}
}
if(sys_Map.Map_UDEF4_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_UDEF4))
{
idb.AddParameter("@Map_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF4", sys_Map.Map_UDEF4);
}
}
if(sys_Map.Map_UDEF5_IsChanged)
{
if (string.IsNullOrEmpty(sys_Map.Map_UDEF5))
{
idb.AddParameter("@Map_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF5", sys_Map.Map_UDEF5);
}
}
if(sys_Map.Stat_IsChanged)
{
if (sys_Map.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Map.Stat);
}
}
idb.AddParameter("@Map_ID", sys_Map.Map_ID);
return idb.ExeCmd(sql);
}
/// <summary>
/// 获取指定的Sys_Map对象集合
/// </summary>
public List<Sys_Map> GetListByWhere(string strCondition)
{
List<Sys_Map> ret = new List<Sys_Map>();
string sql = "SELECT Map_ID,Map_Module,Map_Source,Map_Object,Map_Object1,Map_Object2,Map_Type,Map_UDEF1,Map_UDEF2,Map_UDEF3,Map_UDEF4,Map_UDEF5,Stat FROM Sys_Map WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if(!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'','"'); //防sql注入
sql += strCondition ;
}
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
Sys_Map sys_Map = new Sys_Map();
if (dr["Map_ID"] != DBNull.Value) sys_Map.Map_ID = Convert.ToDecimal(dr["Map_ID"]);
if (dr["Map_Module"] != DBNull.Value) sys_Map.Map_Module = Convert.ToString(dr["Map_Module"]);
if (dr["Map_Source"] != DBNull.Value) sys_Map.Map_Source = Convert.ToString(dr["Map_Source"]);
if (dr["Map_Object"] != DBNull.Value) sys_Map.Map_Object = Convert.ToString(dr["Map_Object"]);
if (dr["Map_Object1"] != DBNull.Value) sys_Map.Map_Object1 = Convert.ToString(dr["Map_Object1"]);
if (dr["Map_Object2"] != DBNull.Value) sys_Map.Map_Object2 = Convert.ToString(dr["Map_Object2"]);
if (dr["Map_Type"] != DBNull.Value) sys_Map.Map_Type = Convert.ToString(dr["Map_Type"]);
if (dr["Map_UDEF1"] != DBNull.Value) sys_Map.Map_UDEF1 = Convert.ToString(dr["Map_UDEF1"]);
if (dr["Map_UDEF2"] != DBNull.Value) sys_Map.Map_UDEF2 = Convert.ToString(dr["Map_UDEF2"]);
if (dr["Map_UDEF3"] != DBNull.Value) sys_Map.Map_UDEF3 = Convert.ToString(dr["Map_UDEF3"]);
if (dr["Map_UDEF4"] != DBNull.Value) sys_Map.Map_UDEF4 = Convert.ToString(dr["Map_UDEF4"]);
if (dr["Map_UDEF5"] != DBNull.Value) sys_Map.Map_UDEF5 = Convert.ToString(dr["Map_UDEF5"]);
if (dr["Stat"] != DBNull.Value) sys_Map.Stat = Convert.ToInt32(dr["Stat"]);
ret.Add(sys_Map);
}
}catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } }
return ret;
}
/// <summary>
/// 获取指定的Sys_Map对象(即:一条记录
/// </summary>
public Sys_Map GetByKey(decimal map_ID)
{
Sys_Map sys_Map = new Sys_Map();
string sql = "SELECT Map_ID,Map_Module,Map_Source,Map_Object,Map_Object1,Map_Object2,Map_Type,Map_UDEF1,Map_UDEF2,Map_UDEF3,Map_UDEF4,Map_UDEF5,Stat FROM Sys_Map WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Map_ID=@Map_ID ";
idb.AddParameter("@Map_ID", map_ID);
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
if (dr["Map_ID"] != DBNull.Value) sys_Map.Map_ID = Convert.ToDecimal(dr["Map_ID"]);
if (dr["Map_Module"] != DBNull.Value) sys_Map.Map_Module = Convert.ToString(dr["Map_Module"]);
if (dr["Map_Source"] != DBNull.Value) sys_Map.Map_Source = Convert.ToString(dr["Map_Source"]);
if (dr["Map_Object"] != DBNull.Value) sys_Map.Map_Object = Convert.ToString(dr["Map_Object"]);
if (dr["Map_Object1"] != DBNull.Value) sys_Map.Map_Object1 = Convert.ToString(dr["Map_Object1"]);
if (dr["Map_Object2"] != DBNull.Value) sys_Map.Map_Object2 = Convert.ToString(dr["Map_Object2"]);
if (dr["Map_Type"] != DBNull.Value) sys_Map.Map_Type = Convert.ToString(dr["Map_Type"]);
if (dr["Map_UDEF1"] != DBNull.Value) sys_Map.Map_UDEF1 = Convert.ToString(dr["Map_UDEF1"]);
if (dr["Map_UDEF2"] != DBNull.Value) sys_Map.Map_UDEF2 = Convert.ToString(dr["Map_UDEF2"]);
if (dr["Map_UDEF3"] != DBNull.Value) sys_Map.Map_UDEF3 = Convert.ToString(dr["Map_UDEF3"]);
if (dr["Map_UDEF4"] != DBNull.Value) sys_Map.Map_UDEF4 = Convert.ToString(dr["Map_UDEF4"]);
if (dr["Map_UDEF5"] != DBNull.Value) sys_Map.Map_UDEF5 = Convert.ToString(dr["Map_UDEF5"]);
if (dr["Stat"] != DBNull.Value) sys_Map.Stat = Convert.ToInt32(dr["Stat"]);
}
}catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } }
return sys_Map;
}
/// <summary>
/// 添加Sys_Map对象(即:一条记录)
/// </summary>
public int Add(Sys_Map sys_Map)
{
string sql = "INSERT INTO Sys_Map (Map_Module,Map_Source,Map_Object,Map_Object1,Map_Object2,Map_Type,Map_UDEF1,Map_UDEF2,Map_UDEF3,Map_UDEF4,Map_UDEF5,Stat) VALUES (@Map_Module,@Map_Source,@Map_Object,@Map_Object1,@Map_Object2,@Map_Type,@Map_UDEF1,@Map_UDEF2,@Map_UDEF3,@Map_UDEF4,@Map_UDEF5,@Stat)";
if (string.IsNullOrEmpty(sys_Map.Map_Module))
{
idb.AddParameter("@Map_Module", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Module", sys_Map.Map_Module);
}
if (string.IsNullOrEmpty(sys_Map.Map_Source))
{
idb.AddParameter("@Map_Source", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Source", sys_Map.Map_Source);
}
if (string.IsNullOrEmpty(sys_Map.Map_Object))
{
idb.AddParameter("@Map_Object", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Object", sys_Map.Map_Object);
}
if (string.IsNullOrEmpty(sys_Map.Map_Object1))
{
idb.AddParameter("@Map_Object1", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Object1", sys_Map.Map_Object1);
}
if (string.IsNullOrEmpty(sys_Map.Map_Object2))
{
idb.AddParameter("@Map_Object2", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Object2", sys_Map.Map_Object2);
}
if (string.IsNullOrEmpty(sys_Map.Map_Type))
{
idb.AddParameter("@Map_Type", DBNull.Value);
}
else
{
idb.AddParameter("@Map_Type", sys_Map.Map_Type);
}
if (string.IsNullOrEmpty(sys_Map.Map_UDEF1))
{
idb.AddParameter("@Map_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF1", sys_Map.Map_UDEF1);
}
if (string.IsNullOrEmpty(sys_Map.Map_UDEF2))
{
idb.AddParameter("@Map_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF2", sys_Map.Map_UDEF2);
}
if (string.IsNullOrEmpty(sys_Map.Map_UDEF3))
{
idb.AddParameter("@Map_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF3", sys_Map.Map_UDEF3);
}
if (string.IsNullOrEmpty(sys_Map.Map_UDEF4))
{
idb.AddParameter("@Map_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF4", sys_Map.Map_UDEF4);
}
if (string.IsNullOrEmpty(sys_Map.Map_UDEF5))
{
idb.AddParameter("@Map_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@Map_UDEF5", sys_Map.Map_UDEF5);
}
if (sys_Map.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Map.Stat);
}
return idb.ExeCmd(sql);
}
/// <summary>
/// 获取所有的Sys_Map对象(即:一条记录
/// </summary>
public List<Sys_Map> GetAll()
{
List<Sys_Map> ret = new List<Sys_Map>();
string sql = "SELECT Map_ID,Map_Module,Map_Source,Map_Object,Map_Object1,Map_Object2,Map_Type,Map_UDEF1,Map_UDEF2,Map_UDEF3,Map_UDEF4,Map_UDEF5,Stat FROM Sys_Map where 1=1 AND ((Stat is null) or (Stat=0) ) order by Map_ID desc ";
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
Sys_Map sys_Map = new Sys_Map();
if (dr["Map_ID"] != DBNull.Value) sys_Map.Map_ID = Convert.ToDecimal(dr["Map_ID"]);
if (dr["Map_Module"] != DBNull.Value) sys_Map.Map_Module = Convert.ToString(dr["Map_Module"]);
if (dr["Map_Source"] != DBNull.Value) sys_Map.Map_Source = Convert.ToString(dr["Map_Source"]);
if (dr["Map_Object"] != DBNull.Value) sys_Map.Map_Object = Convert.ToString(dr["Map_Object"]);
if (dr["Map_Object1"] != DBNull.Value) sys_Map.Map_Object1 = Convert.ToString(dr["Map_Object1"]);
if (dr["Map_Object2"] != DBNull.Value) sys_Map.Map_Object2 = Convert.ToString(dr["Map_Object2"]);
if (dr["Map_Type"] != DBNull.Value) sys_Map.Map_Type = Convert.ToString(dr["Map_Type"]);
if (dr["Map_UDEF1"] != DBNull.Value) sys_Map.Map_UDEF1 = Convert.ToString(dr["Map_UDEF1"]);
if (dr["Map_UDEF2"] != DBNull.Value) sys_Map.Map_UDEF2 = Convert.ToString(dr["Map_UDEF2"]);
if (dr["Map_UDEF3"] != DBNull.Value) sys_Map.Map_UDEF3 = Convert.ToString(dr["Map_UDEF3"]);
if (dr["Map_UDEF4"] != DBNull.Value) sys_Map.Map_UDEF4 = Convert.ToString(dr["Map_UDEF4"]);
if (dr["Map_UDEF5"] != DBNull.Value) sys_Map.Map_UDEF5 = Convert.ToString(dr["Map_UDEF5"]);
if (dr["Stat"] != DBNull.Value) sys_Map.Stat = Convert.ToInt32(dr["Stat"]);
ret.Add(sys_Map);
}
}catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } }
return ret;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Sys_Map model,bool IsValid)
{
bool result = false;
var e = new ModelExceptions();
if(e.IsValid && IsValid){
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(Sys_Map model,bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(Sys_Map model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}