/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <MyCreek.Data.Model.WorkFlowDelegation> DataReaderToList(OracleDataReader dataReader)
{
List <MyCreek.Data.Model.WorkFlowDelegation> List = new List <MyCreek.Data.Model.WorkFlowDelegation>();
MyCreek.Data.Model.WorkFlowDelegation model = null;
while (dataReader.Read())
{
model = new MyCreek.Data.Model.WorkFlowDelegation();
model.ID = dataReader.GetString(0).ToGuid();
model.UserID = dataReader.GetString(1).ToGuid();
model.StartTime = dataReader.GetDateTime(2);
model.EndTime = dataReader.GetDateTime(3);
if (!dataReader.IsDBNull(4))
{
model.FlowID = dataReader.GetString(4).ToGuid();
}
model.ToUserID = dataReader.GetString(5).ToGuid();
model.WriteTime = dataReader.GetDateTime(6);
if (!dataReader.IsDBNull(7))
{
model.Note = dataReader.GetString(7);
}
List.Add(model);
}
return(List);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">MyCreek.Data.Model.WorkFlowDelegation实体类</param>
public int Update(MyCreek.Data.Model.WorkFlowDelegation model)
{
string sql = @"UPDATE WorkFlowDelegation SET
UserID=:UserID,StartTime=:StartTime,EndTime=:EndTime,FlowID=:FlowID,ToUserID=:ToUserID,WriteTime=:WriteTime,Note=:Note
WHERE ID=:ID" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":UserID", OracleDbType.Varchar2, 40)
{
Value = model.UserID
},
new OracleParameter(":StartTime", OracleDbType.Date, 8)
{
Value = model.StartTime
},
new OracleParameter(":EndTime", OracleDbType.Date, 8)
{
Value = model.EndTime
},
model.FlowID == null ? new OracleParameter(":FlowID", OracleDbType.Varchar2, 40)
{
Value = DBNull.Value
} : new OracleParameter(":FlowID", OracleDbType.Varchar2, 40)
{
Value = model.FlowID
},
new OracleParameter(":ToUserID", OracleDbType.Varchar2, 40)
{
Value = model.ToUserID
},
new OracleParameter(":WriteTime", OracleDbType.Date, 8)
{
Value = model.WriteTime
},
model.Note == null ? new OracleParameter(":Note", OracleDbType.NVarchar2, 8000)
{
Value = DBNull.Value
} : new OracleParameter(":Note", OracleDbType.NVarchar2, 8000)
{
Value = model.Note
},
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">MyCreek.Data.Model.WorkFlowDelegation实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(MyCreek.Data.Model.WorkFlowDelegation model)
{
string sql = @"INSERT INTO WorkFlowDelegation
(ID,UserID,StartTime,EndTime,FlowID,ToUserID,WriteTime,Note)
VALUES(:ID,:UserID,:StartTime,:EndTime,:FlowID,:ToUserID,:WriteTime,:Note)" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
},
new OracleParameter(":UserID", OracleDbType.Varchar2, 40)
{
Value = model.UserID
},
new OracleParameter(":StartTime", OracleDbType.Date, 8)
{
Value = model.StartTime
},
new OracleParameter(":EndTime", OracleDbType.Date, 8)
{
Value = model.EndTime
},
model.FlowID == null ? new OracleParameter(":FlowID", OracleDbType.Varchar2, 40)
{
Value = DBNull.Value
} : new OracleParameter(":FlowID", OracleDbType.Varchar2, 40)
{
Value = model.FlowID
},
new OracleParameter(":ToUserID", OracleDbType.Varchar2, 40)
{
Value = model.ToUserID
},
new OracleParameter(":WriteTime", OracleDbType.Date, 8)
{
Value = model.WriteTime
},
model.Note == null ? new OracleParameter(":Note", OracleDbType.NVarchar2, 8000)
{
Value = DBNull.Value
} : new OracleParameter(":Note", OracleDbType.NVarchar2, 8000)
{
Value = model.Note
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">MyCreek.Data.Model.WorkFlowDelegation实体类</param>
public int Update(MyCreek.Data.Model.WorkFlowDelegation model)
{
string sql = @"UPDATE WorkFlowDelegation SET
UserID=@UserID,StartTime=@StartTime,EndTime=@EndTime,FlowID=@FlowID,ToUserID=@ToUserID,WriteTime=@WriteTime,Note=@Note
WHERE ID=@ID" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.UserID
},
new SqlParameter("@StartTime", SqlDbType.DateTime, 8)
{
Value = model.StartTime
},
new SqlParameter("@EndTime", SqlDbType.DateTime, 8)
{
Value = model.EndTime
},
model.FlowID == null ? new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.FlowID
},
new SqlParameter("@ToUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ToUserID
},
new SqlParameter("@WriteTime", SqlDbType.DateTime, 8)
{
Value = model.WriteTime
},
model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, 8000)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.NVarChar, 8000)
{
Value = model.Note
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">MyCreek.Data.Model.WorkFlowDelegation实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(MyCreek.Data.Model.WorkFlowDelegation model)
{
string sql = @"INSERT INTO WorkFlowDelegation
(ID,UserID,StartTime,EndTime,FlowID,ToUserID,WriteTime,Note)
VALUES(@ID,@UserID,@StartTime,@EndTime,@FlowID,@ToUserID,@WriteTime,@Note)" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.UserID
},
new SqlParameter("@StartTime", SqlDbType.DateTime, 8)
{
Value = model.StartTime
},
new SqlParameter("@EndTime", SqlDbType.DateTime, 8)
{
Value = model.EndTime
},
model.FlowID == null ? new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.FlowID
},
new SqlParameter("@ToUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ToUserID
},
new SqlParameter("@WriteTime", SqlDbType.DateTime, 8)
{
Value = model.WriteTime
},
model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, 8000)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.NVarChar, 8000)
{
Value = model.Note
}
};
return(dbHelper.Execute(sql, parameters));
}
public ActionResult Edit(FormCollection collection)
{
MyCreek.Platform.WorkFlowDelegation bworkFlowDelegation = new MyCreek.Platform.WorkFlowDelegation();
MyCreek.Data.Model.WorkFlowDelegation workFlowDelegation = null;
string id = Request.QueryString["id"];
string UserID = string.Empty;
string ToUserID = string.Empty;
string StartTime = string.Empty;
string EndTime = string.Empty;
string FlowID = string.Empty;
string Note = string.Empty;
bool isOneSelf = "1" == Request.QueryString["isoneself"];
Guid delegationID;
if (id.IsGuid(out delegationID))
{
workFlowDelegation = bworkFlowDelegation.Get(delegationID);
if (workFlowDelegation != null)
{
FlowID = workFlowDelegation.FlowID.ToString();
}
}
string oldXML = workFlowDelegation.Serialize();
if (collection != null)
{
UserID = Request.Form["UserID"];
ToUserID = Request.Form["ToUserID"];
StartTime = Request.Form["StartTime"];
EndTime = Request.Form["EndTime"];
FlowID = Request.Form["FlowID"];
Note = Request.Form["Note"];
bool isAdd = !id.IsGuid();
if (workFlowDelegation == null)
{
workFlowDelegation = new MyCreek.Data.Model.WorkFlowDelegation();
workFlowDelegation.ID = Guid.NewGuid();
}
workFlowDelegation.UserID = isOneSelf ? MyCreek.Platform.Users.CurrentUserID : MyCreek.Platform.Users.RemovePrefix(UserID).ToGuid();
workFlowDelegation.EndTime = EndTime.ToDateTime();
if (FlowID.IsGuid())
{
workFlowDelegation.FlowID = FlowID.ToGuid();
}
workFlowDelegation.Note = Note.IsNullOrEmpty() ? null : Note;
workFlowDelegation.StartTime = StartTime.ToDateTime();
workFlowDelegation.ToUserID = MyCreek.Platform.Users.RemovePrefix(ToUserID).ToGuid();
workFlowDelegation.WriteTime = MyCreek.Utility.DateTimeNew.Now;
if (isAdd)
{
bworkFlowDelegation.Add(workFlowDelegation);
MyCreek.Platform.Log.Add("添加了工作委托", workFlowDelegation.Serialize(), MyCreek.Platform.Log.Types.流程相关);
}
else
{
bworkFlowDelegation.Update(workFlowDelegation);
MyCreek.Platform.Log.Add("修改了工作委托", "", MyCreek.Platform.Log.Types.流程相关, oldXML, workFlowDelegation.Serialize());
}
bworkFlowDelegation.RefreshCache();
ViewBag.Script = "alert('保存成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();";
}
ViewBag.FlowOptions = new MyCreek.Platform.WorkFlow().GetOptions(FlowID);
return(View(workFlowDelegation == null ? new MyCreek.Data.Model.WorkFlowDelegation()
{
UserID = MyCreek.Platform.Users.CurrentUserID
} : workFlowDelegation));
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["id"];
string UserID = string.Empty;
string ToUserID = string.Empty;
string StartTime = string.Empty;
string EndTime = string.Empty;
string FlowID = string.Empty;
string Note = string.Empty;
isOneSelf = "1" == Request.QueryString["isoneself"];
Guid delegationID;
if (id.IsGuid(out delegationID))
{
workFlowDelegation = bworkFlowDelegation.Get(delegationID);
if (workFlowDelegation != null)
{
FlowID = workFlowDelegation.FlowID.ToString();
}
}
string oldXML = workFlowDelegation.Serialize();
if (IsPostBack)
{
UserID = Request.Form["UserID"];
ToUserID = Request.Form["ToUserID"];
StartTime = Request.Form["StartTime"];
EndTime = Request.Form["EndTime"];
FlowID = Request.Form["FlowID"];
Note = Request.Form["Note"];
bool isAdd = !id.IsGuid();
if (workFlowDelegation == null)
{
workFlowDelegation = new MyCreek.Data.Model.WorkFlowDelegation();
workFlowDelegation.ID = Guid.NewGuid();
}
workFlowDelegation.UserID = isOneSelf ? MyCreek.Platform.Users.CurrentUserID : MyCreek.Platform.Users.RemovePrefix(UserID).ToGuid();
workFlowDelegation.EndTime = EndTime.ToDateTime();
if (FlowID.IsGuid())
{
workFlowDelegation.FlowID = FlowID.ToGuid();
}
workFlowDelegation.Note = Note.IsNullOrEmpty() ? null : Note;
workFlowDelegation.StartTime = StartTime.ToDateTime();
workFlowDelegation.ToUserID = MyCreek.Platform.Users.RemovePrefix(ToUserID).ToGuid();
workFlowDelegation.WriteTime = MyCreek.Utility.DateTimeNew.Now;
if (isAdd)
{
bworkFlowDelegation.Add(workFlowDelegation);
MyCreek.Platform.Log.Add("添加了工作委托", workFlowDelegation.Serialize(), MyCreek.Platform.Log.Types.流程相关);
}
else
{
bworkFlowDelegation.Update(workFlowDelegation);
MyCreek.Platform.Log.Add("修改了工作委托", "", MyCreek.Platform.Log.Types.流程相关, oldXML, workFlowDelegation.Serialize());
}
bworkFlowDelegation.RefreshCache();
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('保存成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true);
}
FlowOptions = new MyCreek.Platform.WorkFlow().GetOptions(FlowID);
if (workFlowDelegation == null)
{
workFlowDelegation = new MyCreek.Data.Model.WorkFlowDelegation();
}
}
