public List <CRM_BusinessSchedule> GetSchedule(int id)
{
DataTable dt = DBHelper.GetDataTable("select * from CRM_BusinessSchedule where TripID=@id", new Dictionary <string, object>()
{
{ "@id", id }
});
List <CRM_BusinessSchedule> rList = new List <CRM_BusinessSchedule>();
foreach (DataRow row in dt.Rows)
{
CRM_BusinessSchedule r = new CRM_BusinessSchedule()
{
//TripID = id,
CompanyID = Convert.ToInt32(row["CompanyID"]),
CompanyName = row["CompanyName"].ToString(),
EmployeeID = row["EmployeeID"].ToString(),
EmployeeName = row["EmployeeName"].ToString(),
TripTheme = row["TripTheme"].ToString(),
TargetDate = row["TargetDate"].ToString(),
Memo = row["Memo"].ToString()
};
rList.Add(r);
}
return(rList);
}
protected void InsertBtn_Click(object sender, EventArgs e)
{
try
{
ErrorLab.Text = "行程新增成功";
CRM_BusinessSchedule r = new CRM_BusinessSchedule()
{
//TripID = Convert.ToInt32(TripIDTextBox.Text),
CompanyID = Convert.ToInt32(CompanyIDTextBox.Text),
CompanyName = CompanyNameTextBox.Text,
EmployeeID = EmployeeIDTextBox.Text,
EmployeeName = EmployeeNameTextBox.Text,
TripTheme = TripThemeTextBox.Text,
TargetDate = TargetDateTextBox.Text,
Memo = MemoTextBox.Text
};
CRM_BusinessScheduleUtility ru = new CRM_BusinessScheduleUtility();
ru.Insert(r);
}
catch (Exception ex)
{
ErrorLab.Text = "查無此客戶，請先建立客戶資料";
//ErrorLab.Text = ex.Message;
}
}
public void Insert(CRM_BusinessSchedule r)
{
DBHelper.RunTSQL(
"insert into CRM_BusinessSchedule values(@cpid,@cpname,@empid,@empname,@trip,@target,@memo)",
new Dictionary <string, object>()
{
{ "@cpid", r.CompanyID },
{ "@cpname", r.CompanyName },
{ "@empid", r.EmployeeID },
{ "@empname", r.EmployeeName },
{ "@trip", r.TripTheme },
{ "@target", r.TargetDate },
{ "@memo", r.Memo }
});
}
public void Update(CRM_BusinessSchedule r)
{
DBHelper.RunTSQL(
"update CRM_BusinessSchedule set CompanyID=@cpid,CompanyName=@cpname,EmployeeID=@empid,EmployeeName=@empname,TripTheme=@trip,TargetDate=@target,Memo=@memo where TripID=@id",
new Dictionary <string, object>()
{
{ "@id", r.TripID },
{ "@cpid", r.CompanyID },
{ "@cpname", r.CompanyName },
{ "@empid", r.EmployeeID },
{ "@empname", r.EmployeeName },
{ "@trip", r.TripTheme },
{ "@target", r.TargetDate },
{ "@memo", r.Memo }
});
}
//protected void DeleteBtn_Click(object sender, EventArgs e)
//{
// CRM_CustomerUtility ru = new CRM_CustomerUtility();
// int id = Convert.ToInt32(DeleteTextBox.Text);
// ru.Delete(id);
//}
protected void UpdateBtn_Click(object sender, EventArgs e)
{
CRM_BusinessSchedule r = new CRM_BusinessSchedule()
{
TripID = Convert.ToInt32(TripIDHiddenField.Value)
};
r.CompanyID = Convert.ToInt32(CompanyID.Text);
r.CompanyName = CompanyName.Text;
r.EmployeeID = EmployeeID.Text;
r.EmployeeName = EmployeeName.Text;
r.TripTheme = TripTheme.Text;
r.TargetDate = TargetDate.Text;
r.Memo = Memo.Text;
CRM_BusinessScheduleUtility ru = new CRM_BusinessScheduleUtility();
ru.Update(r);
}
public List <CRM_BusinessSchedule> GetSchedules()
{
DataTable dt = DBHelper.GetDataTable("select * from CRM_BusinessSchedule", null);
List <CRM_BusinessSchedule> rList = new List <CRM_BusinessSchedule>();
foreach (DataRow row in dt.Rows)
{
CRM_BusinessSchedule r = new CRM_BusinessSchedule()
{
TripID = Convert.ToInt32(row["TripID"]),
CompanyID = Convert.ToInt32(row["CompanyID"]),
CompanyName = row["CompanyName"].ToString(),
EmployeeID = row["EmployeeID"].ToString(),
EmployeeName = row["EmployeeName"].ToString(),
TripTheme = row["TripTheme"].ToString(),
TargetDate = row["TargetDate"].ToString(),
Memo = row["Memo"].ToString()
};
rList.Add(r);
}
return(rList);
}
