/// <summary>
/// 获取所有组织(含利银辉)
/// </summary>
/// <returns></returns>
public ActionResult GetDataList3()
{
List <ITC_Organization_M> list_mo = OrgaContext.CacheList;//从缓存读取
List <ITC_Organization_M> list_mo1 = new List <ITC_Organization_M>();
foreach (ITC_Organization_M item in list_mo)
{
list_mo1.Add(item);
}
ITC_Organization_M blank = new ITC_Organization_M();
blank.Orga_ID = "";
blank.Organization_FullName = " 所有";
list_mo1.Add(blank);
var list = from f in list_mo1
orderby f.Orga_ID
select new
{
f.Orga_ID,
f.Organization_FullName
};
return(Json(list, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ITC_Organization_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ITC_Organization(");
strSql.Append("Orga_ID,Organization_Order,Organization_createdtime,Organization_Oprt,Organization_Remark,Organization_Name,Organization_Ceo,Organization_Tel,Organization_Mobil,Organization_Fax,Organization_Zip,Organization_address,Organization_ParentID,Organization_Status,Organization_DeptCode,Organization_FullName");
strSql.Append(") values (");
strSql.Append("@Orga_ID,@Organization_Order,@Organization_createdtime,@Organization_Oprt,@Organization_Remark,@Organization_Name,@Organization_Ceo,@Organization_Tel,@Organization_Mobil,@Organization_Fax,@Organization_Zip,@Organization_address,@Organization_ParentID,@Organization_Status,@Organization_DeptCode,@Organization_FullName");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@Orga_ID", SqlDbType.Char, 8),
new SqlParameter("@Organization_Order", SqlDbType.Int, 4),
new SqlParameter("@Organization_createdtime", SqlDbType.DateTime),
new SqlParameter("@Organization_Oprt", SqlDbType.VarChar, 50),
new SqlParameter("@Organization_Remark", SqlDbType.VarChar, 500),
new SqlParameter("@Organization_Name", SqlDbType.VarChar, 500),
new SqlParameter("@Organization_Ceo", SqlDbType.VarChar, 50),
new SqlParameter("@Organization_Tel", SqlDbType.VarChar, 15),
new SqlParameter("@Organization_Mobil", SqlDbType.VarChar, 15),
new SqlParameter("@Organization_Fax", SqlDbType.VarChar, 15),
new SqlParameter("@Organization_Zip", SqlDbType.VarChar, 15),
new SqlParameter("@Organization_address", SqlDbType.VarChar, 50),
new SqlParameter("@Organization_ParentID", SqlDbType.Char, 8),
new SqlParameter("@Organization_Status", SqlDbType.Int),
new SqlParameter("@Organization_DeptCode", SqlDbType.VarChar, 50),
new SqlParameter("@Organization_FullName", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.Orga_ID;
parameters[1].Value = model.Organization_Order;
parameters[2].Value = model.Organization_createdtime;
parameters[3].Value = model.Organization_Oprt;
parameters[4].Value = model.Organization_Remark;
parameters[5].Value = model.Organization_Name;
parameters[6].Value = model.Organization_Ceo;
parameters[7].Value = model.Organization_Tel;
parameters[8].Value = model.Organization_Mobil;
parameters[9].Value = model.Organization_Fax;
parameters[10].Value = model.Organization_Zip;
parameters[11].Value = model.Organization_address;
parameters[12].Value = model.Organization_ParentID;
parameters[13].Value = model.Organization_Status;
parameters[14].Value = model.Organization_DeptCode;
parameters[15].Value = model.Organization_FullName;
int result = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
private List <ITC_Organization_M> DsToList(DataSet ds)
{
List <ITC_Organization_M> list = new List <ITC_Organization_M>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ITC_Organization_M model = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new ITC_Organization_M();
model.Orga_ID = ds.Tables[0].Rows[i]["Orga_ID"].ToString().Trim();
if (ds.Tables[0].Rows[i]["Organization_Order"].ToString() != "")
{
model.Organization_Order = int.Parse(ds.Tables[0].Rows[i]["Organization_Order"].ToString());
}
if (ds.Tables[0].Rows[i]["Organization_createdtime"].ToString() != "")
{
model.Organization_createdtime = DateTime.Parse(ds.Tables[0].Rows[i]["Organization_createdtime"].ToString());
}
if (ds.Tables[0].Rows[i]["Organization_Status"].ToString() != "")
{
model.Organization_Status = int.Parse(ds.Tables[0].Rows[i]["Organization_Status"].ToString());
}
model.Organization_Oprt = ds.Tables[0].Rows[i]["Organization_Oprt"].ToString();
model.Organization_Remark = ds.Tables[0].Rows[i]["Organization_Remark"].ToString();
model.Organization_Name = ds.Tables[0].Rows[i]["Organization_Name"].ToString();
model.Organization_Ceo = ds.Tables[0].Rows[i]["Organization_Ceo"].ToString();
model.Organization_Tel = ds.Tables[0].Rows[i]["Organization_Tel"].ToString();
model.Organization_Mobil = ds.Tables[0].Rows[i]["Organization_Mobil"].ToString();
model.Organization_Fax = ds.Tables[0].Rows[i]["Organization_Fax"].ToString();
model.Organization_Zip = ds.Tables[0].Rows[i]["Organization_Zip"].ToString();
model.Organization_address = ds.Tables[0].Rows[i]["Organization_address"].ToString();
model.Organization_ParentID = ds.Tables[0].Rows[i]["Organization_ParentID"].ToString().Trim();
model.Organization_DeptCode = ds.Tables[0].Rows[i]["Organization_DeptCode"].ToString().Trim();
model.Organization_FullName = ds.Tables[0].Rows[i]["Organization_FullName"].ToString();
if (model.Orga_ID == "")
{
model.Orga_ID = " ";
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 获取名称(缓存)
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static string GetName(string id)
{
if (!string.IsNullOrEmpty(id))
{
ITC_Organization_M model = CacheList.Find(m => m.Orga_ID == id);
if (model != null)
{
return(model.Organization_Name);
}
else
{
return("");
}
}
else
{
return("");
}
}
/// <summary>
/// 获取全称(缓存)
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static string GetFullNameByCache(string id)
{
//if (!string.IsNullOrEmpty(id))
//{
ITC_Organization_M model = CacheList.Find(m => m.Orga_ID == id);
if (model != null)
{
return(model.Organization_FullName);
}
else
{
return("");
}
//}
//else
//{
// return "利银辉";
//}
}
//编辑保存
public ActionResult SaveEdit(ITC_Organization_M model)
{
model.Organization_createdtime = DateTime.Now;
model.Organization_Oprt = UserContext.UserName;
if (uifo.Exists(model.Orga_ID))
{
if (uifo.Update(model))
{
OrgaContext.InitCache();
EventContext.Add(MenuID, string.Format("修改:{0}", model.Orga_ID));
return(Content("保存成功!"));
}
else
{
return(Content("保存失败!"));
}
}
else
{
return(Content("保存失败! 编码[" + model.Orga_ID + "]不存在!"));
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(ITC_Organization_M model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(ITC_Organization_M model)
{
return(dal.Add(model));
}
/// <summary>
/// 获取利家部门编码
/// </summary>
/// <param name="orgaid"></param>
/// <returns></returns>
public string GetDeptCode(string orgaid)
{
ITC_Organization_M model = GetModel(orgaid);
return(model != null ? model.Organization_DeptCode : "");
}
/// <summary>
/// 获取组织全称
/// </summary>
/// <param name="orgaid"></param>
/// <returns></returns>
public string GetOrgaFullName(string orgaid)
{
ITC_Organization_M model = GetModel(orgaid);
return(model != null ? model.Organization_FullName : "");
}
//获取模型
public ActionResult GetModel(string id)
{
ITC_Organization_M mo = uifo.GetModel(id);
return(Json(mo, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ITC_Organization_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ITC_Organization set ");
strSql.Append(" Organization_Order = @Organization_Order , ");
strSql.Append(" Organization_createdtime = @Organization_createdtime , ");
strSql.Append(" Organization_Oprt = @Organization_Oprt , ");
strSql.Append(" Organization_Remark = @Organization_Remark , ");
strSql.Append(" Organization_Name = @Organization_Name , ");
strSql.Append(" Organization_Ceo = @Organization_Ceo , ");
strSql.Append(" Organization_Tel = @Organization_Tel , ");
strSql.Append(" Organization_Mobil = @Organization_Mobil , ");
strSql.Append(" Organization_Fax = @Organization_Fax , ");
strSql.Append(" Organization_Zip = @Organization_Zip , ");
strSql.Append(" Organization_address = @Organization_address , ");
strSql.Append(" Organization_ParentID = @Organization_ParentID,");
strSql.Append(" Organization_Status = @Organization_Status,");
strSql.Append(" Organization_DeptCode = @Organization_DeptCode,");
strSql.Append(" Organization_FullName = @Organization_FullName");
strSql.Append(" where Orga_ID=@Orga_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@Orga_ID", SqlDbType.Char, 8),
new SqlParameter("@Organization_Order", SqlDbType.Int, 4),
new SqlParameter("@Organization_createdtime", SqlDbType.DateTime),
new SqlParameter("@Organization_Oprt", SqlDbType.VarChar, 50),
new SqlParameter("@Organization_Remark", SqlDbType.VarChar, 500),
new SqlParameter("@Organization_Name", SqlDbType.VarChar, 500),
new SqlParameter("@Organization_Ceo", SqlDbType.VarChar, 50),
new SqlParameter("@Organization_Tel", SqlDbType.VarChar, 15),
new SqlParameter("@Organization_Mobil", SqlDbType.VarChar, 15),
new SqlParameter("@Organization_Fax", SqlDbType.VarChar, 15),
new SqlParameter("@Organization_Zip", SqlDbType.VarChar, 15),
new SqlParameter("@Organization_address", SqlDbType.VarChar, 50),
new SqlParameter("@Organization_ParentID", SqlDbType.Char, 8),
new SqlParameter("@Organization_Status", SqlDbType.Int),
new SqlParameter("@Organization_DeptCode", SqlDbType.VarChar, 50),
new SqlParameter("@Organization_FullName", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.Orga_ID;
parameters[1].Value = model.Organization_Order;
parameters[2].Value = model.Organization_createdtime;
parameters[3].Value = model.Organization_Oprt;
parameters[4].Value = model.Organization_Remark;
parameters[5].Value = model.Organization_Name;
parameters[6].Value = model.Organization_Ceo;
parameters[7].Value = model.Organization_Tel;
parameters[8].Value = model.Organization_Mobil;
parameters[9].Value = model.Organization_Fax;
parameters[10].Value = model.Organization_Zip;
parameters[11].Value = model.Organization_address;
parameters[12].Value = model.Organization_ParentID;
parameters[13].Value = model.Organization_Status;
parameters[14].Value = model.Organization_DeptCode;
parameters[15].Value = model.Organization_FullName;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
