public void UpdateDept(DeptEntity entity)
{
base.UseTran((tran) =>
{
DbCommand cmd = base.Database.GetStoredProcCommand("P_UpdateDept");
base.Database.AddInParameter(cmd, "DeptId", DbType.Int32, entity.DeptId);
base.Database.AddInParameter(cmd, "DeptNo", DbType.String, entity.DeptNo);
base.Database.AddInParameter(cmd, "DeptName", DbType.String, entity.DeptName);
base.Database.AddInParameter(cmd, "Remark", DbType.String, entity.Remark);
base.Database.AddInParameter(cmd, "LastModifyId", DbType.String, entity.LastModifyId);
base.Database.ExecuteNonQuery(cmd, tran);
});
}
public int CreateDept(DeptEntity entity)
{
int entityid = 0;
base.UseTran((tran) =>
{
DbCommand cmd = base.Database.GetStoredProcCommand("P_CreateDept");
base.Database.AddOutParameter(cmd, "DeptId", DbType.Int32, 4);
base.Database.AddInParameter(cmd, "DeptNo", DbType.String, entity.DeptNo);
base.Database.AddInParameter(cmd, "DeptName", DbType.String, entity.DeptName);
base.Database.AddInParameter(cmd, "Remark", DbType.String, entity.Remark);
base.Database.AddInParameter(cmd, "PId", DbType.Int32, entity.PId);
base.Database.AddInParameter(cmd, "CreateId", DbType.String, entity.CreateId);
base.Database.ExecuteNonQuery(cmd, tran);
entityid = (int)base.Database.GetParameterValue(cmd, "DeptId");
});
return entityid;
}
private static DeptEntity[] DataTableToEntitys(DataTable dt)
{
if (dt == null)
return null;
var results = new DeptEntity[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
results[i] = DataRowToEntity(dt.Rows[i]);
}
return results;
}
private static DeptEntity DataRowToEntity(DataRow row)
{
if (row == null)
return null;
var result = new DeptEntity()
{
DeptId = (int)(row["DeptId"]),
DeptNo = (string)(row["DeptNo"]),
DeptName = (string)(row["DeptName"]),
Remark = (string)(row["Remark"]),
PId = (int)(row["PId"]),
Level_Path = (string)(row["Level_Path"]),
Level_Num = (int)(row["Level_Num"]),
Level_Total = (int)(row["Level_Total"]),
Level_Deep = (int)(row["Level_Deep"]),
CreateId = (string)(row["CreateId"]),
CreateDate = (DateTime)(row["CreateDate"]),
LastModifyId = (string)(row["LastModifyId"]),
LastModifyDate = (DateTime)(row["LastModifyDate"]),
Deleted = (bool)(row["Deleted"]),
};
return result;
}