/// <summary>
/// 更新レコード メソッド
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult Update(BackupServerGroup model)
{
int result = -1;
if (Session["LoginId"] == null)
{
result = -99;
}
else
{
try
{
model.updateDate = CommonUtil.DateTimeNowToString();
model.updater = Session["LoginId"].ToString();
if (model.memo == null)
{
model.memo = string.Empty;
}
result = groupSerivce.UpdateBackupServerGroup(model);
}
catch (Exception ex)
{
result = -10;
logger.Error(ex.Message);
}
}
Response.Write(result);
Response.End();
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="BackupServerGroup"></param>
/// <param name="conn"></param>
/// <returns></returns>
public int UpdateBackupServerGroup(BackupServerGroup BackupServerGroup, OdbcConnection conn)
{
int result = -1;
string sql = "UPDATE backupServerGroup SET backupServerGroupName = ?,"
+ " monitorServerID = ?,"
+ " memo = ?,"
+ " updater = ?,"
+ " updateDate = ?,"
+ " synchronismFlg = 0"
+ " WHERE id = ?";
OdbcParameter[] para = new OdbcParameter[] {
new OdbcParameter("@backupServerGroupName", BackupServerGroup.backupServerGroupName),
new OdbcParameter("@monitorServerID", BackupServerGroup.monitorServerID),
new OdbcParameter("@memo", BackupServerGroup.memo),
new OdbcParameter("@updater", BackupServerGroup.updater),
new OdbcParameter("@updateDate", BackupServerGroup.updateDate),
new OdbcParameter("@id", BackupServerGroup.id)
};
try
{
result = db.Udaquery(sql, conn, para);
}
catch (Exception e)
{
throw e;
}
return(result);
}
/// <summary>
/// init the backup server modifification page
/// </summary>
private void FrmTransfer_Load(object sender, EventArgs e)
{
//get monitor server by record id
if (!String.IsNullOrWhiteSpace(id))
{
IBackupServerService bs = BLLFactory.ServiceAccess.CreateBackupServer();
backupServer = bs.GetBackupServerById(Convert.ToInt32(id));
this.txtTrId.Text = backupServer.id.ToString();
this.txtTrName.Text = backupServer.backupServerName;
this.txtTrIp.Text = backupServer.backupServerIP;
this.txtTrMemo.Text = backupServer.memo;
this.txtTraccount.Text = backupServer.account;
this.txtTrPass.Text = backupServer.password;
this.txtTrStfile.Text = backupServer.startFile;
//Set the related MonitorServer.
this.innerBackupServerGroup = groupSerivce.GetBackupServerGroupByBackupServerID(Convert.ToInt32(id));
foreach (object item in this.cobMonitorServer.Items)
{
ComboBoxItem cobItem = (ComboBoxItem)item;
if (cobItem.Value != null && cobItem.Value.Equals(this.innerBackupServerGroup.monitorServerID))
{
this.cobMonitorServer.SelectedItem = item;
break;
}
}
this.txtBackupServerGroupName.Text = this.innerBackupServerGroup.backupServerGroupName;
}
else
{
this.IP_StartFolder = CommonUtil.GetTransfer_IP_StartFolder();
}
}
/// <summary>
/// データ削除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Delete(int id)
{
int result = -1;
if (Session["LoginId"] == null)
{
result = -99;
}
else
{
try
{
string loginId = Session["LoginId"].ToString();
result = bkService.DeleteBackupServer(id, loginId);
BackupServerGroup backupServerGroup = groupSerivce.GetBackupServerGroupByBackupServerID(id);
result = groupSerivce.DeleteBackupServerGroup(Convert.ToInt32(backupServerGroup.id), loginId);
//delete relation detail
result = groubDetailService.DeleteBackupServerGroupDetail(id, Convert.ToInt32(backupServerGroup.id), loginId);
}
catch (Exception ex)
{
result = -10;
logger.Error(ex.Message);
}
}
Response.Write(result);
Response.End();
return(null);
}
public ActionResult Add(BackupServerGroup model)
{
int result = -1;
if (Session["LoginId"] == null)
{
result = -99;
}
else
{
try
{
string dt = CommonUtil.DateTimeNowToString();
model.creater = Session["LoginId"].ToString();
model.createDate = dt;
model.updater = Session["LoginId"].ToString();
model.updateDate = dt;
model.deleteFlg = 0;
result = groupSerivce.InsertBackupServerGroup(model);
}
catch (Exception ex)
{
result = -10;
logger.Error(ex.Message);
}
}
Response.Write(result);
Response.End();
return(null);
}
public int UpdateBackupServerGroup(BackupServerGroup BackupServerGroup, SqlConnection conn)
{
int result = -1;
string sql = "UPDATE backupServerGroup SET backupServerGroupName = @servername,"
+ " memo = @memo,"
+ " updater = @updater,"
+ " updateDate = @updateDate"
+ " WHERE id = @id";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@servername", BackupServerGroup.backupServerGroupName),
new SqlParameter("@memo", BackupServerGroup.memo),
new SqlParameter("@updater", BackupServerGroup.updater),
new SqlParameter("@updateDate", BackupServerGroup.updateDate),
new SqlParameter("@id", BackupServerGroup.id)
};
try
{
result = db.Udaquery(sql, conn, para);
}
catch (Exception e)
{
throw e;
}
return(result);
}
public ActionResult Add(BackupServerGroup model, BackupServer bkModel)
{
int result = -1;
//session获取值
if (Session["LoginId"] == null)
{
result = -99;
}
else
{
try
{
string dt = CommonUtil.DateTimeNowToString();
string loginId = Session["LoginId"].ToString();
model.backupServerGroupName = bkModel.backupServerName;
model.creater = loginId;
model.createDate = dt;
model.updater = loginId;
model.updateDate = dt;
model.deleteFlg = 0;
result = groupSerivce.InsertBackupServerGroup(model);
bkModel.creater = loginId;
bkModel.createDate = dt;
bkModel.updater = loginId;
bkModel.updateDate = dt;
bkModel.deleteFlg = 0;
result = bkService.InsertBackupServer(bkModel);
//add relation detail
IList <BackupServerGroup> groupList = groupSerivce.GetBackupServerGroupByName(model.backupServerGroupName);
IList <BackupServer> bkList = bkService.GetBackupServerListByName(bkModel.backupServerName);
if (groupList.Count > 0 && bkList.Count > 0)
{
BackupServerGroupDetail modelDetail = new BackupServerGroupDetail();
modelDetail.backupServerGroupId = Convert.ToInt32(groupList[0].id);
modelDetail.backupServerId = Convert.ToInt32(bkList[0].id);
modelDetail.deleteFlg = 0;
modelDetail.creater = loginId;
modelDetail.createDate = dt;
modelDetail.updater = loginId;
modelDetail.updateDate = dt;
result = groubDetailService.InsertBackupServerGroupDetail(modelDetail);
}
}
catch (Exception ex)
{
result = -10;
logger.Error(ex.Message);
}
}
Response.Write(result);
Response.End();
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="BackupServerGroup"></param>
/// <param name="conn"></param>
/// <returns></returns>
public int InsertBackupServerGroup(BackupServerGroup BackupServerGroup, OdbcConnection conn)
{
try
{
return(db.insert(BackupServerGroup, "backupServerGroup", conn));
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
///
/// </summary>
private void dgrdMain_Load()
{
//init dgrdMain
//not allowed user add new row to datagridview
this.dgrdMain.AllowUserToAddRows = false;
this.dgrdMain.Rows.Clear();
//init table data
IBackupServerGroupService bss = BLLFactory.ServiceAccess.CreateBackupServerGroupService();
IList <MonitorServer> lists = MonitorServerService.GetMonitorServerList();
int i = 1;
foreach (MonitorServer list in lists)
{
string monitorServerId = list.id;
string backupGroupid = "0";
DataGridViewRow dgvr = new DataGridViewRow();
try
{
foreach (DataGridViewColumn c in dgrdMain.Columns)
{
dgvr.Cells.Add(c.CellTemplate.Clone() as DataGridViewCell);//add row cells
}
dgvr.Cells[0].Value = list.id;
dgvr.Cells[1].Value = i.ToString();
dgvr.Cells[2].Value = list.monitorServerName;
BackupServerGroup result = bss.GetBackupServerGroupByMonitorId(Int32.Parse(list.id));
if (result != null)
{
dgvr.Cells[3].Value = result.backupServerGroupName; dgvr.Cells[3].Tag = result.id;
backupGroupid = result.id;
}
else
{
dgvr.Cells[3].Value = "バックアップ先選択"; dgvr.Cells[3].Tag = 0;
}
dgvr.Cells[4].Value = "";
dgvr.Cells[5].Value = "転送始める"; dgvr.Cells[5].Tag = 0;
dgvr.Cells[6].Value = "転送停止";
this.dgrdMain.Rows.Add(dgvr);
int rowIndex = dgvr.Cells[0].RowIndex;
if (backupGroupid != "0" && !GlobalVariable.stopTransferThread.ContainsKey(list.id))
{
bool transfer = ButtonTansferStart(list.id, backupGroupid, rowIndex);
}
i++;
}
catch (Exception ex)
{
logger.Error(ex.Message);
continue;
}
}
}
/// <summary>
/// init the monitor server modifification page
/// </summary>
private void FrmGroupTransfer_Load(object sender, EventArgs e)
{
//get monitor server by record id
IBackupServerGroupService bs = BLLFactory.ServiceAccess.CreateBackupServerGroupService();
backupServerGroup = bs.GetBackupServerGroupById(Convert.ToInt32(id));
this.txtMonitorId.Text = backupServerGroup.id.ToString();
this.txtMonitorName.Text = backupServerGroup.backupServerGroupName;
this.txtMonitorMemo.Text = backupServerGroup.memo;
this.cobMonitorServer.SelectedValue = backupServerGroup.monitorServerID;
}
public int InsertBackupServerGroup(BackupServerGroup BackupServerGroup)
{
OdbcConnection conn;
int count = 0;
using (conn = OdbcHelper.CreateConntion())
{
conn.Open();
count = BackupServerGroupDal.InsertBackupServerGroup(BackupServerGroup, conn);
conn.Close();
}
return(count);
}
/// <summary>
/// 編集ページ
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public ActionResult Edit(int id)
{
try
{
ViewData["model"] = groupSerivce.GetBackupServerGroupById(id);
ViewData["msList"] = mService.GetMonitorServerList();
}
catch (Exception ex)
{
ViewData["model"] = new BackupServerGroup();
ViewData["msList"] = new List <MonitorBackupServer>();
logger.Error(ex.Message);
}
return(View());
}
/// <summary>
/// データ更新
/// </summary>
/// <param name="bkModel"></param>
/// <returns></returns>
public ActionResult Update(BackupServerGroup model, BackupServer bkModel)
{
int result = -1;
//session获取值
if (Session["LoginId"] == null)
{
result = -99;
}
else
{
try
{
model.id = Request.Form["group_id"];
model.updater = bkModel.updater = Session["LoginId"].ToString();
model.updateDate = bkModel.updateDate = CommonUtil.DateTimeNowToString();
if (model.memo == null)
{
model.memo = string.Empty;
}
if (bkModel.memo == null)
{
bkModel.memo = string.Empty;
}
if (bkModel.ssbpath == null)
{
bkModel.ssbpath = string.Empty;
}
result = groupSerivce.UpdateBackupServerGroup(model);
result = bkService.UpdateBackupServer(bkModel);
}
catch (Exception ex)
{
result = -10;
logger.Error(ex.Message);
}
}
Response.Write(result);
Response.End();
return(null);
}
