private void BindData()
{
try
{
List <MemosEntity> NewsLst = new Memos().GetMemos();
grdMemosLst.DataSource = NewsLst;
grdMemosLst.DataBind();
}
catch (Exception ex)
{
LoggingService.LogError("WebParts", ex.Message);
}
}
protected void BtnWrite_Click(object sender, EventArgs e)
{
Memos memos = new Memos();
memos.Name = TxtName.Text;
memos.Email = TxtEmail.Text;
memos.Title = TxtTitle.Text;
memos.PostDate = DateTime.Now;
memos.PostIP = Request.UserHostAddress;
var connString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
using (var conn = new SqlConnection(connString))
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
try
{
// 저장 프로시저를 호출해서 처리 (쿼리문이 없으니까 통일감을 줌)
SqlCommand cmd = new SqlCommand("WriteMemo", conn); // 저장 프로시저 WriteMemo 를 호출
cmd.CommandType = System.Data.CommandType.StoredProcedure;
// 쿼리문으로 처리
//var query = @"Insert Memos(Name, Email, Title, PostDate, PostIP)
// Values(@Name, @Email, @Title, @PostDate, @PostIP)";
//SqlCommand cmd = new SqlCommand(query, conn);
//cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@Name", memos.Name);
cmd.Parameters.AddWithValue("@Email", memos.Email);
cmd.Parameters.AddWithValue("@Title", memos.Title);
cmd.Parameters.AddWithValue("@PostDate", memos.PostDate);
cmd.Parameters.AddWithValue("@PostIP", memos.PostIP);
cmd.ExecuteNonQuery();
LblResult.Text = "저장되었습니다";
}
catch (Exception ex)
{
LblResult.Text = $"예외발생 : {ex}";
}
}
}
/// <summary>
/// Проверить адресата.
/// </summary>
/// <param name="document">Документ.</param>
/// <param name="task">Задача на согласование.</param>
/// <returns>True, если адресат совпадает.</returns>
private Structures.ConditionBase.ConditionResult CheckAddressee(IOfficialDocument document, IApprovalTask task)
{
if (Memos.Is(document))
{
var addressee = Memos.As(document).Addressee;
if (addressee != null)
{
return(Structures.ConditionBase.ConditionResult.Create(_obj.Addressees.Any(c => Equals(c.Addressee, addressee)), string.Empty));
}
else
{
return(Structures.ConditionBase.ConditionResult.Create(null, Conditions.Resources.MemoAddresseeIsEmpty));
}
}
return(Structures.ConditionBase.ConditionResult.Create(null, Conditions.Resources.CheckAddresseePossibleOnlyToMemo));
}
protected void BtnWrite_Click(object sender, EventArgs e)
{
Memos memos = new Memos();
memos.Name = TxtName.Text;
memos.Email = TxtEmail.Text;
memos.Title = TxtTitle.Text;
memos.PostDate = DateTime.Now;
memos.PostIP = Request.UserHostAddress;
var connString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connString))
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
var query = @"Writememo";
try
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", memos.Name);
cmd.Parameters.AddWithValue("@Email", memos.Email);
cmd.Parameters.AddWithValue("@Title", memos.Title);
cmd.Parameters.AddWithValue("@PostDate", memos.PostDate);
cmd.Parameters.AddWithValue("@PostIP", memos.PostIP);
cmd.ExecuteNonQuery();
conn.Close();
LblDisplay.Text = "저장되었습니다.";
}
catch (Exception ex)
{
LblDisplay.Text = $"오류 : {ex}";
}
}
}
public override int GetHashCode()
{
unchecked
{
var hashCode = TaskId;
hashCode = (hashCode * 397) ^ (Content != null ? Content.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ CreateTime.GetHashCode();
hashCode = (hashCode * 397) ^ StartTime.GetHashCode();
hashCode = (hashCode * 397) ^ (int)Priority;
hashCode = (hashCode * 397) ^ (int)Urgency;
hashCode = (hashCode * 397) ^ (int)Status;
hashCode = (hashCode * 397) ^ EstimatedDuration;
hashCode = (hashCode * 397) ^ EndTime.GetHashCode();
hashCode = (hashCode * 397) ^ (Memos != null ? Memos.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Tags != null ? Tags.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (ParentTaskId.GetHashCode());
hashCode = (hashCode * 397) ^ (PreTaskIds != null ? PreTaskIds.GetHashCode() : 0);
return(hashCode);
}
}
protected void BtnModify_Click(object sender, EventArgs e)
{
Memos memos = new Memos();
memos.Num = Convert.ToInt32(Request["Num"]);
memos.Name = TxtName.Text;
memos.Email = TxtEmail.Text;
memos.Title = TxtTitle.Text;
var connString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connString))
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
var query = @"ModifyMemo";
try
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Num", memos.Num);
cmd.Parameters.AddWithValue("@Name", memos.Name);
cmd.Parameters.AddWithValue("@Email", memos.Email);
cmd.Parameters.AddWithValue("@Title", memos.Title);
cmd.ExecuteNonQuery();
conn.Close();
Response.Redirect($"FrmMemoView.aspx?Num={Request["Num"]}");
}
catch (Exception ex)
{
LblError.Text = $"오류 : {ex}";
}
}
}
// Delete Object (Memo or Arrow)
void DeleteObject(object sender, EventArgs args)
{
switch (StatusLabel.Text)
{
case "Memo Tapped":
Memo TappedMemo = (Memo)WhichObject(TappedObject);
foreach (Arrow arrow in TappedMemo.Arrows)
{
// Remove all arrows from Memo and MemoBoard
if (arrow.From == TappedMemo)
{
arrow.To.Arrows.Remove(arrow);
}
if (arrow.To == TappedMemo)
{
arrow.From.Arrows.Remove(arrow);
}
MemoBoard.Children.Remove(arrow.Body);
}
Memos.Remove(TappedMemo);
StatusLabel.Text = "Memo Deleted";
break;
case "Arrow Tapped":
case "Linking Memo":
Arrow TappedArrow = (Arrow)WhichObject(TappedObject);
Memo from = TappedArrow.From; from.Arrows.Remove(TappedArrow);
Memo to = TappedArrow.To; to.Arrows.Remove(TappedArrow);
LinkMemoButton.Text = "->"; // change the button label
StatusLabel.Text = "Arrow Deleted";
break;
}
MemoBoard.Children.Remove(TappedObject);
DeleteObjectButton.IsEnabled = false;
}
/// <summary>
/// Установить доступность свойств.
/// </summary>
/// <param name="refreshParameters">Информация по этапам для обновления формы задачи на согласование по регламенту.</param>
public virtual void SetEnabledProperties(Structures.ApprovalTask.RefreshParameters refreshParameters)
{
var taskProperties = _obj.State.Properties;
taskProperties.Addressee.IsEnabled = false;
taskProperties.ReqApprovers.IsEnabled = false;
if (_obj.ApprovalRule != null)
{
taskProperties.Addressee.IsEnabled = refreshParameters.AddresseeIsEnabled;
}
var isExchange = _obj.DeliveryMethod != null && _obj.DeliveryMethod.Sid == Constants.MailDeliveryMethod.Exchange;
taskProperties.ExchangeService.IsEnabled = refreshParameters.ExchangeServiceIsEnabled;
var document = _obj.DocumentGroup.OfficialDocuments.FirstOrDefault();
if (isExchange && OfficialDocuments.Is(document))
{
if (document.Versions.Any())
{
var isIncomingDocument = Docflow.PublicFunctions.OfficialDocument.Remote.CanSendAnswer(document);
var isFormalizedDocument = Docflow.AccountingDocumentBases.Is(document) && Docflow.AccountingDocumentBases.As(document).IsFormalized == true;
taskProperties.DeliveryMethod.IsEnabled = refreshParameters.DeliveryMethodIsEnabled;
taskProperties.ExchangeService.IsEnabled = refreshParameters.ExchangeServiceIsEnabled;
}
}
// Не давать менять адресата в согласовании служебных записок.
if (Memos.Is(document))
{
taskProperties.Addressee.IsEnabled = false;
}
// Не давать изменять способ доставки для исходящих писем на несколько адресатов.
if (OutgoingDocumentBases.Is(document) && OutgoingDocumentBases.As(document).IsManyAddressees == true)
{
taskProperties.DeliveryMethod.IsEnabled = false;
}
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="mo"></param>
/// <returns></returns>
public bool AddMemosInfo(Memos mo)
{
string sql = "up_Add_Memos";
SqlParameter[] para =
{
new SqlParameter("@uName", mo.UserName),
new SqlParameter("@TelPhone", mo.TelPhone),
//new SqlParameter("@Zhiwei",mo.Zhiwei),
//new SqlParameter("@Address",mo.CopAddress),
new SqlParameter("@cop", mo.Cop),
new SqlParameter("@content", mo.MemosContent),
//new SqlParameter("@brand",mo.BrandName),
//new SqlParameter("@web",mo.BrandWeb),
//new SqlParameter("@obj",mo.Pkobj),
//new SqlParameter("@hanye",mo.Hanye)
new SqlParameter("@Email", mo.Email)
};
if (DbHelper.ExecuteCommandByProc(sql, para) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindMemo(int id)
{
mem = new MemosManager().GetMemos(id);
}
public List <CNMemo> GetAllMemos()
{
return(Memos.ToList());
}
public bool HasMemo(int memoId)
{
return(Memos.Any(x => x.MemoId == memoId));
}
public bool Equals(CNTask other)
{
if (ReferenceEquals(null, other))
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return(TaskId == other.TaskId &&
string.Equals(Content, other.Content) &&
CreateTime.Equals(other.CreateTime) &&
StartTime.Equals(other.StartTime) &&
Priority == other.Priority &&
Urgency == other.Urgency &&
Status == other.Status &&
EstimatedDuration == other.EstimatedDuration &&
EndTime.Equals(other.EndTime) &&
(Memos == null && other.Memos == Memos) || (Memos != null && other.Memos != null && Memos.Count == other.Memos.Count && !Memos.Except(other.Memos).Any()) &&
(Tags == null && other.Tags == Tags) || (Tags != null && other.Tags != null && Tags.Count == other.Tags.Count && !Tags.Except(other.Tags).Any()) &&
Equals(ParentTaskId, other.ParentTaskId) &&
(PreTaskIds == null && other.PreTaskIds == PreTaskIds) || (PreTaskIds != null && other.PreTaskIds != null && PreTaskIds.Count == other.PreTaskIds.Count && !PreTaskIds.Except(other.PreTaskIds).Any()));
}
public bool HasMemo()
{
return(Memos.Any());
}
public static async Task <int> SaveServiceVisitMemo(ServiceVisit serviceVisit, Memos memo)
{
ServiceVisitDBInfo serviceVisitDBInfo = await App.ServiceVisitsDatabase.GetServiceVisitAsync(serviceVisit.ServiceVisitId);
serviceVisitDBInfo.ContactMemo = memo.ContactMemo;
serviceVisitDBInfo.FSMMemo = memo.FSMMemo;
serviceVisitDBInfo.InductionMemo = memo.InductionMemo;
serviceVisitDBInfo.OHSMemo = memo.OHSMemo;
serviceVisitDBInfo.ServiceMemo = memo.ServiceMemo;
serviceVisitDBInfo.updateMemos = true;
var result = await App.ServiceVisitsDatabase.UpdateServiceVisitAsync(serviceVisitDBInfo);
return(result);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="mo"></param>
/// <returns></returns>
public bool AddMemosInfo(Memos mo)
{
return(IMemos.AddMemosInfo(mo));
}
