/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public int AddRecord(HOrgnizationData model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("set nocount on; ");
strSql.Append("insert into HOrgnization(");
strSql.Append("departNo,departNm,uppDepartId,departLeader,isEffect,isDel,isrtDt,isrtEmpId,updtDt,updtEmpId,mark)");
strSql.Append(" values (");
strSql.Append("@departNo,@departNm,@uppDepartId,@departLeader,@isEffect,@isDel,@isrtDt,@isrtEmpId,@updtDt,@updtEmpId,@mark)");
strSql.Append("; select @@identity; set nocount off; ");
SqlParameter[] parameters = {
new SqlParameter("@departNo", SqlDbType.NVarChar,10),
new SqlParameter("@departNm", SqlDbType.NVarChar,50),
new SqlParameter("@uppDepartId", SqlDbType.Int),
new SqlParameter("@departLeader", SqlDbType.Int),
new SqlParameter("@isEffect", SqlDbType.Bit),
new SqlParameter("@isDel", SqlDbType.Bit),
new SqlParameter("@isrtDt", SqlDbType.DateTime),
new SqlParameter("@isrtEmpId", SqlDbType.Int),
new SqlParameter("@updtDt", SqlDbType.DateTime),
new SqlParameter("@updtEmpId", SqlDbType.Int),
new SqlParameter("@mark", SqlDbType.NVarChar,500)
};
parameters[0].Value = model.departNo;
parameters[1].Value = model.departNm;
parameters[2].Value = model.uppDepartId;
parameters[3].Value = model.departLeader;
parameters[4].Value = model.isEffect;
parameters[5].Value = model.isDel;
parameters[6].Value = model.isrtDt == string.Empty ? null : model.isrtDt;
parameters[7].Value = model.isrtEmpId;
parameters[8].Value = model.updtDt == string.Empty ? null : model.updtDt;
parameters[9].Value = model.updtEmpId;
parameters[10].Value = model.mark;
int id = 0;
try
{
object ret = SqlHelper.ExecuteScalar(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
if (ret != null && ret != DBNull.Value)
{
id = Convert.ToInt32(ret);
}
}
catch (Exception ex)
{
throw ex;
}
return id;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
HOrgnizationData model = new HOrgnizationData();
HOrgnizationBB orgnizationBB = new HOrgnizationBB();
try
{
if (this.State == "1")
{
this.SetModel(ref model);
model.departNo = "";
model.isrtDt = DateTime.Now.ToString();
model.isrtEmpId = this.currentUser.empId;
model.isDel = false;
this.IdValue = orgnizationBB.AddRecord(model);
}
else if (this.State == "2")
{
model = orgnizationBB.GetModel(this.IdValue);
this.SetModel(ref model);
model.updtDt = DateTime.Now.ToString();
model.updtEmpId = this.currentUser.empId;
orgnizationBB.ModifyRecord(model);
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
return;
}
finally
{
orgnizationBB.Dispose();
}
Response.Redirect("HOrgnizationList.aspx?itemNo=" + this.itemNo + "&pTypeNo=main", false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["id"] != null && Request.Params["id"].Trim() != "")
{
this.IdValue = Convert.ToInt32(Request.Params["id"]);
}
if (Request.Params["state"] != null && Request.Params["state"].Trim() != string.Empty)
{
this.State = Request.Params["state"].ToString();
switch (this.State)
{
case "1": //add
break;
case "2": //update
//���ؿؼ�
HOrgnizationBB orgnizationBB = new HOrgnizationBB();
HOrgnizationData orgnizationData = new HOrgnizationData();
try
{
orgnizationData = orgnizationBB.GetModel(this.IdValue);
this.ShowInfo(this.IdValue);
}
finally
{
orgnizationBB.Dispose();
}
break;
default:
break;
}
}
}
}
private void SetModel(ref HOrgnizationData model)
{
model.departNo = this.departNo.Text;
model.departNm = this.departNm.Text;
if (this.uppDepartId.Value != "")
{
model.uppDepartId = Convert.ToInt32(this.uppDepartId.Value);
}
else
{
model.uppDepartId = 0;
}
if (this.departLeader.Value != "")
{
model.departLeader = Convert.ToInt32(this.departLeader.Value);
}
else
{
model.departLeader = 0;
}
model.isEffect = this.isEffect.Checked;
model.mark = this.mark.Text;
}
//*****************************************************************************
//do it later do it later do it later
//*****************************************************************************
/// <summary>
/// �����ϼ����Ż�ȡ�����������±���
/// </summary>
/// <param name="uppDepartId">�ϼ�����Id</param>
/// <returns></returns>
public string GetNewDepartNo(int uppDepartId)
{
string uppDepartNo = "";
if (uppDepartId != 0)
{
HOrgnizationData orgnizationData = new HOrgnizationData();
orgnizationData = this.GetModel(uppDepartId);
uppDepartNo = orgnizationData.departNo;
}
string newDepartNo = "";
StringBuilder strSql = new StringBuilder();
strSql.Append("select max(departNo) as maxDepartNo from HOrgnization");
strSql.Append(" where isnull(uppDepartId,0) = @uppDepartId");
if (uppDepartId != 0)
{
strSql.Append(" and departNo like '" + uppDepartNo + "%'");
}
SqlParameter[] parameters = {
new SqlParameter("@uppDepartId", SqlDbType.Int)
};
parameters[0].Value = uppDepartId;
DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow row = ds.Tables[0].Rows[0];
if (row["maxDepartNo"] != DBNull.Value)
{
string maxDepartNo = row["maxDepartNo"].ToString().Substring(uppDepartNo.Length);
newDepartNo = (Convert.ToInt32(maxDepartNo) + 1).ToString("00");
}
else
{
newDepartNo = "01";
}
}
else
{
newDepartNo = "01";
}
//��Ϊ��ϵͳȨ������ʹ�ò��ű���������Ȩ���ƣ����������˲��ű�����Ͻ���Ҫ������ϱ�xx��λ�����ʽ
if (newDepartNo.Length > 2)
throw new Exception("���ű��볬����λ���ƣ�����ϵϵͳ����Ա���������ű������");
newDepartNo = uppDepartNo + newDepartNo;
return newDepartNo;
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public bool ModifyRecord(HOrgnizationData model)
{
bool ret = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update HOrgnization set ");
strSql.Append("departNo=@departNo,");
strSql.Append("departNm=@departNm,");
strSql.Append("uppDepartId=@uppDepartId,");
strSql.Append("departLeader=@departLeader,");
strSql.Append("isEffect=@isEffect,");
strSql.Append("isDel=@isDel,");
strSql.Append("isrtDt=@isrtDt,");
strSql.Append("isrtEmpId=@isrtEmpId,");
strSql.Append("updtDt=@updtDt,");
strSql.Append("updtEmpId=@updtEmpId,");
strSql.Append("mark=@mark");
strSql.Append(" where departId = @departId ");
SqlParameter[] parameters = {
new SqlParameter("@departId", SqlDbType.Int),
new SqlParameter("@departNo", SqlDbType.NVarChar,10),
new SqlParameter("@departNm", SqlDbType.NVarChar,50),
new SqlParameter("@uppDepartId", SqlDbType.Int),
new SqlParameter("@departLeader", SqlDbType.Int),
new SqlParameter("@isEffect", SqlDbType.Bit),
new SqlParameter("@isDel", SqlDbType.Bit),
new SqlParameter("@isrtDt", SqlDbType.DateTime),
new SqlParameter("@isrtEmpId", SqlDbType.Int),
new SqlParameter("@updtDt", SqlDbType.DateTime),
new SqlParameter("@updtEmpId", SqlDbType.Int),
new SqlParameter("@mark", SqlDbType.NVarChar,500)
};
parameters[0].Value = model.departId;
parameters[1].Value = model.departNo;
parameters[2].Value = model.departNm;
parameters[3].Value = model.uppDepartId;
parameters[4].Value = model.departLeader;
parameters[5].Value = model.isEffect;
parameters[6].Value = model.isDel;
parameters[7].Value = model.isrtDt == string.Empty ? null : model.isrtDt;
parameters[8].Value = model.isrtEmpId;
parameters[9].Value = model.updtDt == string.Empty ? null : model.updtDt;
parameters[10].Value = model.updtEmpId;
parameters[11].Value = model.mark;
try
{
SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
ret = true;
}
catch (Exception ex)
{
throw ex;
}
return ret;
}
/// <summary>
/// �õ�һ��model
/// </summary>
/// <param name="departId">����ֵ</param>
/// <returns>model</returns>
public HOrgnizationData GetModel(int departId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select departId,departNo,departNm,uppDepartId,departLeader,isEffect,isDel,isrtDt,isrtEmpId,updtDt,updtEmpId,mark from HOrgnization");
strSql.Append(" where departId = @departId ");
SqlParameter[] parameters = {
new SqlParameter("@departId", SqlDbType.Int)
};
parameters[0].Value = departId;
HOrgnizationData model = new HOrgnizationData();
DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow row = ds.Tables[0].Rows[0];
if (row["departId"] != DBNull.Value)
{
model.departId = Convert.ToInt32(row["departId"]);
}
if (row["departNo"] != DBNull.Value)
{
model.departNo = Convert.ToString(row["departNo"]);
}
if (row["departNm"] != DBNull.Value)
{
model.departNm = Convert.ToString(row["departNm"]);
}
if (row["uppDepartId"] != DBNull.Value)
{
model.uppDepartId = Convert.ToInt32(row["uppDepartId"]);
}
if (row["departLeader"] != DBNull.Value)
{
model.departLeader = Convert.ToInt32(row["departLeader"]);
}
if (row["isEffect"] != DBNull.Value)
{
model.isEffect = Convert.ToBoolean(row["isEffect"]);
}
if (row["isDel"] != DBNull.Value)
{
model.isDel = Convert.ToBoolean(row["isDel"]);
}
if (row["isrtDt"] != DBNull.Value)
{
model.isrtDt = Convert.ToString(row["isrtDt"]);
}
if (row["isrtEmpId"] != DBNull.Value)
{
model.isrtEmpId = Convert.ToInt32(row["isrtEmpId"]);
}
if (row["updtDt"] != DBNull.Value)
{
model.updtDt = Convert.ToString(row["updtDt"]);
}
if (row["updtEmpId"] != DBNull.Value)
{
model.updtEmpId = Convert.ToInt32(row["updtEmpId"]);
}
if (row["mark"] != DBNull.Value)
{
model.mark = Convert.ToString(row["mark"]);
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得当前部门
/// </summary>
/// <returns></returns>
public HOrgnizationData GetCurrentDept()
{
HOrgnizationData departData = null;
if (this.currentUser.nowDepartId != 0)
{
int departId = this.currentUser.nowDepartId;
HOrgnizationBB departBB = new HOrgnizationBB();
try
{
departData = departBB.GetModel(departId);
}
finally
{
departBB.Dispose();
}
}
if (null == departData)
{
departData = new HOrgnizationData();
}
return departData;
}
/// <summary>
/// ɾ��
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDel_Click(object sender, EventArgs e)
{
bool retChecked = false;
HOrgnizationBB orgnizationBB = new HOrgnizationBB();
try
{
//��ȡѡ�е�����Id
foreach (GridViewRow gvrow in this.grid.Rows)
{
CheckBox chkId = (CheckBox)gvrow.FindControl("chkId");
if (chkId.Checked == true)
{
retChecked = true;
int id = int.Parse(chkId.ValidationGroup);
HOrgnizationData orgnizationData = new HOrgnizationData();
orgnizationData = orgnizationBB.GetModel(id);
orgnizationData.isDel = true;
orgnizationBB.ModifyRecord(orgnizationData);
}
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
return;
}
finally
{
orgnizationBB.Dispose();
}
if (retChecked)
{
this.BindGrid();
}
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public bool ModifyRecord(HOrgnizationData model)
{
//����ϼ����Ÿı䣬��ӱ������������в��ŵIJ��ű�����������
if (model.uppDepartId != 0)
{
HOrgnizationData oldModel = new HOrgnizationData();
oldModel = this.GetModel(model.departId);
if (oldModel.uppDepartId != model.uppDepartId)
{
model.departNo = this.GetNewDepartNo(model.uppDepartId);
this.orgnizationDB.ModifyRecord(model);
this.UpdateChildrenDepartNo(model.departId);
}
else
{
this.orgnizationDB.ModifyRecord(model);
}
}
else
{
this.orgnizationDB.ModifyRecord(model);
}
return true;
}
/// <summary>
/// ����һ������
/// </summary>
/// <param name="model">model</param>
public int AddRecord(HOrgnizationData model)
{
//��ֵ���ű��
model.departNo = this.GetNewDepartNo(model.uppDepartId);
return this.orgnizationDB.AddRecord(model);
}