/// <summary>
/// 插入语句
/// </summary>
/// <param name="context"></param>
private void DepartmentInsert(HttpContext context)
{
CrisisInterfere.DepartmentService.DepartmentServiceClient dc = new DepartmentService.DepartmentServiceClient();
CrisisInterfere.DepartmentService.DepartmentEntity model = new DepartmentService.DepartmentEntity();
var D_name = context.Request["D_name"];
var D_Remark = context.Request["D_Remark"];
var D_chiID = context.Request["D_chiID"];
CrisisInterfere.DepartmentService.DepartmentEntity de = new DepartmentService.DepartmentEntity();
de._d_name = D_name;
de._d_remark = D_Remark;
de._d_chiid = D_chiID;
long DResult = dc.DepartmentInsert(de);
if (DResult > 0)
{
//插入授权编码关系表
DepartmentLicense_InfoEntity entityInfo = new DepartmentLicense_InfoEntity();
entityInfo._d_id = Convert.ToInt32(DResult);
entityInfo._is_delete = 0;
entityInfo._licensecode = "";//sesion获取用户的授权编码
entityInfo._createtime = DateTime.Now;
EOInsert(entityInfo);
context.Response.Write("1");
}
else
{
context.Response.Write("0");
}
}
public void DepartmentAselect(HttpContext context)
{
CrisisInterfere.DepartmentService.DepartmentServiceClient dc = new DepartmentService.DepartmentServiceClient();
CrisisInterfere.DepartmentService.DepartmentEntity model = new DepartmentService.DepartmentEntity();
int D_ID = Convert.ToInt32(context.Request["UP_D_ID"]);
model = dc.Aselect(D_ID);
string json = JsonConvert.SerializeObject(model);
context.Response.Write(json);
}
/// <summary>
/// 查询出部门列表
/// </summary>
/// <param name="Starindex">开始编号</param>
/// <param name="Endindex">结束编号</param>
/// <param name="context">默认</param>
private void InitGaugePages(string Starindex, string Endindex, string Ecode, HttpContext context)
{
CrisisInterfere.DepartmentService.DepartmentServiceClient dc = new DepartmentService.DepartmentServiceClient();
CrisisInterfere.DepartmentService.DepartmentEntity model = new DepartmentService.DepartmentEntity();
try
{
PageInfo page = new PageInfo();
DataSet ds = new DataSet();
string EnterpriseCode = "";
EnterpriseCode = Common.GetSessionValue("EnterpriseCode", context);
if (EnterpriseCode == null)
{
return;
}
ds = dc.DepartmentDT(Starindex, Endindex, EnterpriseCode);
//dt = MgrServices.Department.DepartmentDT();
DataTable SourceTemp = new DataTable();
if (ds != null && ds.Tables.Count > 0)
{
page.recordsTotal = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
SourceTemp = ds.Tables[1];
if (SourceTemp != null && SourceTemp.Rows.Count > 0)
{
foreach (DataRow DTR in SourceTemp.Rows)
{
var num = dc.Department_num(Convert.ToInt32(DTR["D_id"].ToString()), Ecode);
String[] arr =
{
// DTR["D_id"].ToString(), //部门ID
DTR["PageIndex"].ToString(), //序号
DTR["D_name"].ToString(), //部门名称
DTR["D_Remark"].ToString(), //部门描述
// DTR["D_number"].ToString(),//部门人数
num.ToString(),
""//操作
// DTR["D_chiID"].ToString()//所属部门
};
page.data.Add(arr);
}
}
}
page.recordsFiltered = page.recordsTotal;
String json = Common.ObjectToJson(page);
context.Response.Write(json);
}
catch
{
}
}
/// <summary>
/// 删除一条数据到回收站。
/// </summary>
/// <param name="context"></param>
private void DepartmentDelete(HttpContext context)
{
CrisisInterfere.DepartmentService.DepartmentServiceClient dc = new DepartmentService.DepartmentServiceClient();
CrisisInterfere.DepartmentService.DepartmentEntity model = new DepartmentService.DepartmentEntity();
int D_ID = Convert.ToInt32(context.Request["D_ID"]);
if (dc.UPdataDelete(D_ID))
{
context.Response.Write("1");
}
else
{
context.Response.Write("0");
}
}
public void DepartmentD_updeta(HttpContext context)
{
CrisisInterfere.DepartmentService.DepartmentServiceClient dc = new DepartmentService.DepartmentServiceClient();
CrisisInterfere.DepartmentService.DepartmentEntity model = new DepartmentService.DepartmentEntity();
int D_ID = Convert.ToInt32(context.Request["UP_D_IDS"]);
string D_name = context.Request["D_name"];
string D_Remark = context.Request["D_Remark"];
model._d_id = D_ID;
model._d_remark = D_Remark;
model._d_name = D_name;
if (dc.updata(model))
{
context.Response.Write("1");
}
else
{
context.Response.Write("0");
}
}
/// <summary>
/// 下拉列表的展示
/// </summary>
/// <param name="context"></param>
private void DepartmentRemark(HttpContext context)
{
CrisisInterfere.DepartmentService.DepartmentServiceClient dc = new DepartmentService.DepartmentServiceClient();
CrisisInterfere.DepartmentService.DepartmentEntity model = new DepartmentService.DepartmentEntity();
try
{
string LoginName = "";
LoginName = Common.GetSessionValue("loginName", context);
if (LoginName == null)
{
return;
}
DataTable dt = new DataTable();
string EnterpriseCode = "";
EnterpriseCode = Common.GetSessionValue("EnterpriseCode", context);
if (EnterpriseCode == null)
{
return;
}
dt = dc.Departments(EnterpriseCode);
if (dt != null && dt.Rows.Count > 0)
{
ComboxMes mex = new ComboxMes();
List <ComboxMes> listT = new List <ComboxMes>();
foreach (DataRow DTR in dt.Rows)
{
mex = new ComboxMes();
mex.Text = DTR["D_name"].ToString();
mex.Value = DTR["D_ID"].ToString();
listT.Add(mex);
}
context.Response.Write(new JavaScriptSerializer().Serialize(listT));
}
}
catch
{
}
}
