/// <summary>
/// ����һ������
/// </summary>
public bool Add(DepartmentInfo model,out int DeptID)
{
string procName = "OA_SP_SM_Department_ADD";
LogBuilder log = new LogBuilder();
#region ��־��Ϣ
log.Desc = "��Ӳ���";
log.Method = MethodBase.GetCurrentMethod().Name;
log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName;
log.StroreProcedure = procName;
log.Append("DepartmentInfo", model);
#endregion
DeptID = 0;
try
{
int rowsAffected;
SqlParameter[] parameters = {
new SqlParameter("@DepID", SqlDbType.Int,4),
new SqlParameter("@DepName", SqlDbType.VarChar,50),
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@Remark", SqlDbType.VarChar,200),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@Creator", SqlDbType.Int,4)};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.DepName;
parameters[2].Value = model.ParentID;
parameters[3].Value = model.Remark;
parameters[4].Value = model.State;
parameters[5].Value = model.Creator;
Mssql.ExecuteProc(procName, parameters, out rowsAffected);
if (rowsAffected > 0)
{
if (parameters[0] != null)
{
DeptID = (int)parameters[0].Value;
log.Append("DeptID", DeptID, ParamDirection.OUT);
}
}
}
catch (Exception ex)
{
log.Exception = ex.ToString();
log.Error();
}
finally
{
log.Debug();
}
return DeptID>0;
}
protected void btnSave_Click(object sender, EventArgs e)
{
DepartmentDAL departDal = new DepartmentDAL();
DepartmentInfo departInfo = new DepartmentInfo();
departInfo.DepName = txtDepName.Text;
departInfo.Remark = txtRemark.Value;
if (hidparentID.Value == "")
{
departInfo.ParentID = 0;
}
else
{
departInfo.ParentID = Convert.ToInt32(hidparentID.Value);
}
bool result = departDal.Exists(0, departInfo.DepName);
if (result)
{
int depID = 0;
result =departDal.Add(departInfo,out depID);
if (result)
{
TsOAPage.ShowMsgRefresh(this.Page, lang.SaveSuccess);
return;
}
else
{
TsOAPage.ShowMsgRefresh(this.Page, lang.SaveFail);
return;
}
}
else
{
TsOAPage.ShowMsgRefresh(this.Page, string.Format(lang.NameExists,lang.DepName));
return;
}
}
/// <summary>
/// ��ѯ�����б�
/// </summary>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="totalRows"></param>
/// <param name="ParentID">�ϼ�ID</param>
/// <returns></returns>
public IList<DepartmentInfo> GetList(int pageSize, int pageIndex, out int totalRows,int ParentID=-1)
{
List<DepartmentInfo> DeparList = null;
DepartmentInfo ui = null;
totalRows = 0;
MssqlDatabase database = null;
LogBuilder log = new LogBuilder();
try
{
string procName = "OA_SP_SM_Department_GetList";
#region ��־��Ϣ
log.Desc = "��ò��������б�";
log.Method = MethodBase.GetCurrentMethod().Name;
log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName;
log.StroreProcedure = procName;
log.Append("PageSize", pageSize.ToString());
log.Append("PageIndex", pageIndex.ToString());
log.Append("ParentID", ParentID.ToString());
#endregion
SqlParameter[] param ={
database.MakeInParam("@ParentID",SqlDbType.Int,4,ParentID),
database.MakeInParam("@PageSize", SqlDbType.Int,4, pageSize),
database.MakeInParam("@PageIndex", SqlDbType.Int,4,pageIndex),
database.MakeOutParam("@TotalRows",SqlDbType.Int,4)
};
DataTable dt = null;
database.ExecuteProc(procName, param, out dt);
totalRows = SqlComponents.ReaderGetInt32(param[3].Value);
log.Append("TotalRows", totalRows.ToString(), ParamDirection.INOUT);
if (dt != null && dt.Rows.Count > 0)
{
DeparList = new List<DepartmentInfo>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ui = new DepartmentInfo();
ui.RowId = SqlComponents.ReaderGetInt32(dt.Rows[i]["rowid"]);
ui.DepID = SqlComponents.ReaderGetInt32(dt.Rows[i]["DepID"]);
ui.ParentID = SqlComponents.ReaderGetInt32(dt.Rows[i]["ParentID"]);
ui.State = SqlComponents.ReaderGetInt32(dt.Rows[i]["State"]);
ui.DepName = SqlComponents.ReaderGetString(dt.Rows[i]["DepName"]);
ui.Remark = SqlComponents.ReaderGetString(dt.Rows[i]["Remark"]);
DeparList.Add(ui);
}
}
return DeparList;
}
catch (Exception ex)
{
log.Exception = ex.ToString();
log.Error();
}
finally
{
log.Debug();
if (database != null)
{
database.Close();
}
}
return null;
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(DepartmentInfo model)
{
string procName = "OA_SP_SM_Department_Update";
LogBuilder log = new LogBuilder();
#region ��־��Ϣ
log.Desc = "���²���";
log.Method = MethodBase.GetCurrentMethod().Name;
log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName;
log.StroreProcedure = procName;
log.Append("DepartmentInfo", model);
#endregion
try
{
int rowsAffected = 0;
SqlParameter[] parameters = {
new SqlParameter("@DepID", SqlDbType.Int,4),
new SqlParameter("@DepName", SqlDbType.VarChar,50),
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@Remark", SqlDbType.VarChar,200),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@ModifyTime", SqlDbType.DateTime,4),
new SqlParameter("@ModityUesrID", SqlDbType.Int,4)};
parameters[0].Value = model.DepID;
parameters[1].Value = model.DepName;
parameters[2].Value = model.ParentID;
parameters[3].Value = model.Remark;
parameters[4].Value = model.State;
parameters[5].Value = model.Created;
parameters[6].Value = model.Creator;
Mssql.ExecuteProc(procName, parameters, out rowsAffected);
if (rowsAffected > 0)
{
return true;
}
}
catch (Exception ex)
{
log.Exception = ex.ToString();
log.Error();
}
finally
{
log.Debug();
}
return false;
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public DepartmentInfo GetDepartmentInfo(int DepID)
{
DepartmentInfo model = null;
string procName = "OA_SP_SM_Department_GetModel";
LogBuilder log = new LogBuilder();
#region ��־��Ϣ
log.Desc = "��ȡ������Ϣ";
log.Method = MethodBase.GetCurrentMethod().Name;
log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName;
log.StroreProcedure = procName;
log.Append("DepID", DepID);
#endregion
try
{
SqlParameter[] parameters = {
new SqlParameter("@DepID", SqlDbType.Int,4)
};
parameters[0].Value = DepID;
DataTable dt = Mssql.ExecuteProcDt(procName, parameters);
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
model = new DepartmentInfo();
model.DepID = DepID;
model.DepName = SqlComponents.ReaderGetString(dr["DepName"]);
model.ParentID = SqlComponents.ReaderGetInt32(dr["ParentID"]);
model.Remark = SqlComponents.ReaderGetString(dr["Remark"]);
model.State = SqlComponents.ReaderGetInt32(dr["State"]);
return model;
}
}
catch (Exception ex)
{
log.Exception = ex.ToString();
log.Error();
}
finally
{
log.Debug();
}
return null;
}