public override bool Edit(FtpInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Domains", Value = ParameterHelper.ConvertValue(m.Domains)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpServer", Value = ParameterHelper.ConvertValue(m.FtpServer)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpUserName", Value = ParameterHelper.ConvertValue(m.FtpUserName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpPassword", Value = ParameterHelper.ConvertValue(m.FtpPassword)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsSynchronization", Value = ParameterHelper.ConvertValue(m.IsSynchronization)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CloseDate", Value = ParameterHelper.ConvertValue(m.CloseDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override int InsertIdentityId(FtpInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Domains", Value = ParameterHelper.ConvertValue(m.Domains)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpServer", Value = ParameterHelper.ConvertValue(m.FtpServer)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpUserName", Value = ParameterHelper.ConvertValue(m.FtpUserName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpPassword", Value = ParameterHelper.ConvertValue(m.FtpPassword)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsSynchronization", Value = ParameterHelper.ConvertValue(m.IsSynchronization)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CloseDate", Value = ParameterHelper.ConvertValue(m.CloseDate)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
protected void btnSave_Click(object sender, EventArgs e)
{
FtpInfoVO info = new FtpInfoVO();
info.CloseDate = DateTime.Now;
info.CreateDate = DateTime.Now;
info.Desc = txtName.Value;
info.Domains = txtDomain.Value;
info.FtpPassword = txtUserPwd.Value;
info.FtpServer = txtFtpServer.Value;
info.FtpUserName = txtUserName.Value;
info.IsSynchronization = chkIsState.Checked ? 1 : 0;
info.Name = txtName.Value;
FtpInfoBLL.Instance.Add(info);
Response.Redirect("/Admin/Pages/FtpList.aspx");
}
public override string GetOtherConditionByModel(FtpInfoVO m)
{
return("");
}
public override string GetOrderByModel(FtpInfoVO m)
{
return("");
}
