public static IList <FormApproveListEntity> Get(FormType formType)
{
var sql = string.Format("select {0} from form_approve_list where form_type = @p_form_type order by sequence", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_form_type", DbType.Int32, (int)formType);
var list = new List <FormApproveListEntity>();
using (var reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new FormApproveListEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
public static void Save(FormApproveListEntity entity)
{
var sql = string.Format(@"insert into form_approve_list({0})
values(@p_id, @p_form_type, @p_hospital_id, @p_approver_type, @p_approver_id, @p_sequence,
@p_created_id, @p_created_time, @p_updated_id, @p_updated_time)", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, entity.Id);
db.AddInParameter(dc, "p_form_type", DbType.Int32, (int)entity.FormType);
db.AddInParameter(dc, "p_hospital_id", DbType.String, entity.HospitalId);
db.AddInParameter(dc, "p_approver_type", DbType.Int32, (int)entity.ApproverType);
db.AddInParameter(dc, "p_approver_id", DbType.String, entity.ApproverId);
db.AddInParameter(dc, "p_sequence", DbType.Int32, entity.Sequence);
db.AddInParameter(dc, "p_created_id", DbType.String, entity.CreatedId);
db.AddInParameter(dc, "p_created_time", DbType.DateTime, entity.CreatedTime);
db.AddInParameter(dc, "p_updated_id", DbType.String, entity.CreatedId);
db.AddInParameter(dc, "p_updated_time", DbType.DateTime, entity.CreatedTime);
db.ExecuteNonQuery(dc);
}
public static FormApproveListEntity Get(string id)
{
var sql = string.Format("select {0} from form_approve_list where id = @p_id", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, id);
using (var reader = db.ExecuteReader(dc))
{
if (reader.Read())
{
var entity = new FormApproveListEntity();
entity.Init(reader);
return(entity);
}
}
return(null);
}
public JsonNetResult SaveFormApprove(FormApproveListEntity entity)
{
try
{
if (entity == null)
{
throw new Exception("The form approver is empty.");
}
if (entity.FormType == FormType.None)
{
throw new Exception("The audit form is not being chosen.");
}
if (entity.ApproverType == ApproverType.None)
{
throw new Exception("The approver type is not being chosen.");
}
if ((entity.ApproverType == ApproverType.ChoosePerson || entity.ApproverType == ApproverType.ChooseUnitManager) && string.IsNullOrEmpty(entity.ApproverId))
{
throw new Exception("The approver is empty.");
}
entity.Id = Guid.NewGuid().ToString();
entity.CreatedId = entity.UpdatedId = this.UserContext.UserId;
entity.CreatedTime = entity.UpdatedTime = DateTime.Now;
new FormApproveListService().Save(entity);
return(JsonNet(new ResponseResult(true, entity.Id)));
}
catch (Exception e)
{
return(JsonNet(new ResponseResult(false, e)));
}
}
public void Save(FormApproveListEntity entity)
{
FormApproveListRepository.Save(entity);
}
