/// <summary>
/// 通过文本将实体填充
/// </summary>
/// <param name="type"></param>
private void FillEntityByTextBox(int type)
{
if (type == 1)
{
HomogeneousMineralInfo h**o = curMineral as HomogeneousMineralInfo;
h**o.ID = 0;
h**o.ChineseName = this.Txt_ChineseName.Text.Trim();
h**o.EnglishName = this.Txt_EnglishName.Text.Trim();
h**o.ChemicalFormula = this.Txt_ChemicalFormula.Text.Trim();
h**o.Syngony = this.Txt_Syngony.Text.Trim();
h**o.NonUniformity = this.Txt_NonUniformity.Text.Trim();
h**o.Reflectivity = this.Txt_Reflectivity.Text.Trim();
h**o.Hardness = this.Txt_Hardness.Text.Trim();
h**o.ReflectionColor = this.Txt_ReflectionColor.Text.Trim();
if (!string.IsNullOrEmpty(this.Txt_Rr.Text.Trim()))
{
h**o.Rr = this.Txt_Rr.Text.Trim().Replace("°", null);
}
else
{
h**o.Rr = this.Txt_Rr.Text.Trim();
}
h**o.DRr = this.Txt_DRr.Text.Trim();
h**o.InternalReflection = this.Txt_InternalReflection.Text.Trim();
h**o.Origin = this.Txt_Origin.Text.Trim();
h**o.IMK = this.Txt_IMK.Text.Trim();
curMineral = h**o;
}
else
{
HeterogeneousMineralInfo hete = curMineral as HeterogeneousMineralInfo;
hete.ID = 0;
hete.ChineseName = this.Txt_ChineseName_No.Text.Trim();
hete.EnglishName = this.Txt_EnglishName_No.Text.Trim();
hete.ChemicalFormula = this.Txt_ChemicalFormula_No.Text.Trim();
hete.Syngony = this.Txt_Syngony_No.Text.Trim();
hete.NonUniformity = this.Txt_NonUniformity_No.Text.Trim();
hete.Reflectivity = this.Txt_Reflectivity_No.Text.Trim();
hete.Hardness = this.Txt_Hardness_No.Text.Trim();
hete.ReflectionColor = this.Txt_ReflectionColor_No.Text.Trim();
hete.Bireflection = this.Txt_Bireflection_No.Text.Trim();
if (!string.IsNullOrEmpty(this.Txt_Ar_No.Text.Trim()))
{
hete.Ar = this.Txt_Ar_No.Text.Trim().Replace("°", null);
}
else
{
hete.Ar = this.Txt_Ar_No.Text.Trim();
}
hete.DAr = this.Txt_DAr_No.Text.Trim();
hete.Rs = this.Txt_Rs_No.Text.Trim();
hete.Ps = this.Txt_Ps_No.Text.Trim();
hete.DRr = this.Txt_DRr_No.Text.Trim();
hete.ReflectionDAR = this.Txt_ReflectionDAR_No.Text.Trim();
hete.InternalReflection = this.Txt_InternalReflection_No.Text.Trim();
hete.Origin = this.Txt_Origin_No.Text.Trim();
hete.IMK = this.Txt_IMK_No.Text.Trim();
curMineral = hete;
}
}
/// <summary>
/// 通过实体删除
/// </summary>
/// <param name="mineral"></param>
public static void DeleteByEntity(IMineral mineral)
{
string sql =
String.Format(
"DELETE FROM " + (mineral.mineralType == 1 ? "HomogeneousMineral" : "HeterogeneousMineral") +
" WHERE ChineseName='{0}'",
(mineral.mineralType == 1
? ((HomogeneousMineralInfo)mineral).ChineseName
: ((HeterogeneousMineralInfo)mineral).ChineseName));
SqlHelper.ExecuteNonQuery(sql);
}
public ActionResult Remove(long removeId = -1, string authorizeRemove = "", long unapproveId = -1, string authorizeUnapprove = "")
{
string message;
if (!string.IsNullOrWhiteSpace(authorizeRemove) && removeId.ToString().Equals(authorizeRemove))
{
ApplicationUser authedUser = UserManager.FindById(User.Identity.GetUserId());
IMineral obj = TemplateCache.Get <IMineral>(removeId);
if (obj == null)
{
message = "That does not exist";
}
else if (obj.Remove(authedUser.GameAccount, authedUser.GetStaffRank(User)))
{
LoggingUtility.LogAdminCommandUsage("*WEB* - RemoveMineral[" + removeId.ToString() + "]", authedUser.GameAccount.GlobalIdentityHandle);
message = "Delete Successful.";
}
else
{
message = "Error; Removal failed.";
}
}
else if (!string.IsNullOrWhiteSpace(authorizeUnapprove) && unapproveId.ToString().Equals(authorizeUnapprove))
{
ApplicationUser authedUser = UserManager.FindById(User.Identity.GetUserId());
IMineral obj = TemplateCache.Get <IMineral>(unapproveId);
if (obj == null)
{
message = "That does not exist";
}
else if (obj.ChangeApprovalStatus(authedUser.GameAccount, authedUser.GetStaffRank(User), ApprovalState.Returned))
{
LoggingUtility.LogAdminCommandUsage("*WEB* - UnapproveMineral[" + unapproveId.ToString() + "]", authedUser.GameAccount.GlobalIdentityHandle);
message = "Unapproval Successful.";
}
else
{
message = "Error; Unapproval failed.";
}
}
else
{
message = "You must check the proper remove or unapprove authorization radio button first.";
}
return(RedirectToAction("Index", new { Message = message }));
}
/// <summary>
/// 根据输入的矿物种类查询
/// </summary>
/// <param name="mineral">代表矿物种类 1表示均质矿物，2表示非均质矿物</param>
/// <returns></returns>
public static DataTable Query(IMineral mineral)
{
if (mineral.mineralType == 1)
{
string sql = String.Format("SELECT * FROM HomogeneousMineral");
return(SqlHelper.ExecuteDataTable(sql));
}
else if (mineral.mineralType == 2)
{
string sql = String.Format("SELECT * FROM HeterogeneousMineral");
return(SqlHelper.ExecuteDataTable(sql));
}
return(new DataTable());
}
public ActionResult Edit(long id, string ArchivePath = "")
{
IMineral obj = TemplateCache.Get <IMineral>(id);
if (obj == null)
{
return(RedirectToAction("Index", new { Message = "That does not exist" }));
}
AddEditMineralsViewModel vModel = new AddEditMineralsViewModel(ArchivePath, obj)
{
AuthedUser = UserManager.FindById(User.Identity.GetUserId())
};
return(View("~/Views/GameAdmin/Minerals/Edit.cshtml", vModel));
}
/// <summary>
/// 通过实体将文本框填充
/// </summary>
/// <param name="mineral"></param>
private void InitTextByEntity(IMineral mineral)
{
curMineral = mineral;
if (mineral.mineralType == 1) //若是均质矿物
{
HomogeneousMineralInfo homogeneousMineral = (HomogeneousMineralInfo)mineral;
this.Txt_ChineseName.Text = homogeneousMineral.ChineseName;
this.Txt_EnglishName.Text = homogeneousMineral.EnglishName;
this.Txt_ChemicalFormula.Text = homogeneousMineral.ChemicalFormula;
this.Txt_Syngony.Text = homogeneousMineral.Syngony;
this.Txt_NonUniformity.Text = homogeneousMineral.NonUniformity;
this.Txt_Reflectivity.Text = homogeneousMineral.Reflectivity;
this.Txt_Hardness.Text = homogeneousMineral.Hardness;
this.Txt_ReflectionColor.Text = homogeneousMineral.ReflectionColor;
this.Txt_Rr.Text = string.IsNullOrEmpty(homogeneousMineral.Rr)?"":homogeneousMineral.Rr + "°";
this.Txt_DRr.Text = homogeneousMineral.DRr;
this.Txt_InternalReflection.Text = homogeneousMineral.InternalReflection;
this.Txt_Origin.Text = homogeneousMineral.Origin;
this.Txt_IMK.Text = homogeneousMineral.IMK;
ShowHomoMineralInfoView();
}
else if (mineral.mineralType == 2) //若是非均质矿物
{
HeterogeneousMineralInfo heterogeneousMineral = (HeterogeneousMineralInfo)mineral;
this.Txt_ChineseName_No.Text = heterogeneousMineral.ChineseName;
this.Txt_EnglishName_No.Text = heterogeneousMineral.EnglishName;
this.Txt_ChemicalFormula_No.Text = heterogeneousMineral.ChemicalFormula;
this.Txt_Syngony_No.Text = heterogeneousMineral.Syngony;
this.Txt_NonUniformity_No.Text = heterogeneousMineral.NonUniformity;
this.Txt_Reflectivity_No.Text = heterogeneousMineral.Reflectivity;
this.Txt_Hardness_No.Text = heterogeneousMineral.Hardness;
this.Txt_ReflectionColor_No.Text = heterogeneousMineral.ReflectionColor;
this.Txt_Bireflection_No.Text = heterogeneousMineral.Bireflection;
this.Txt_Ar_No.Text = string.IsNullOrEmpty(heterogeneousMineral.Ar) ? "" : heterogeneousMineral.Ar + "°";
this.Txt_DAr_No.Text = heterogeneousMineral.DAr;
this.Txt_Rs_No.Text = heterogeneousMineral.Rs;
this.Txt_Ps_No.Text = heterogeneousMineral.Ps;
this.Txt_DRr_No.Text = heterogeneousMineral.DRr;
this.Txt_ReflectionDAR_No.Text = heterogeneousMineral.ReflectionDAR;
this.Txt_InternalReflection_No.Text = heterogeneousMineral.InternalReflection;
this.Txt_Origin_No.Text = heterogeneousMineral.Origin;
this.Txt_IMK_No.Text = heterogeneousMineral.IMK;
ShowHeteMineralInfoView();
}
}
public ActionResult Edit(long id, AddEditMineralsViewModel vModel)
{
string message = string.Empty;
ApplicationUser authedUser = UserManager.FindById(User.Identity.GetUserId());
IMineral obj = TemplateCache.Get <IMineral>(id);
if (obj == null)
{
message = "That does not exist";
return(RedirectToAction("Index", new { Message = message }));
}
obj.Name = vModel.DataObject.Name;
obj.HelpText = vModel.DataObject.HelpText;
obj.Solubility = vModel.DataObject.Solubility;
obj.Fertility = vModel.DataObject.Fertility;
obj.AmountMultiplier = vModel.DataObject.AmountMultiplier;
obj.Rarity = vModel.DataObject.Rarity;
obj.PuissanceVariance = vModel.DataObject.PuissanceVariance;
obj.ElevationRange = vModel.DataObject.ElevationRange;
obj.TemperatureRange = vModel.DataObject.TemperatureRange;
obj.HumidityRange = vModel.DataObject.HumidityRange;
obj.Dirt = vModel.DataObject.Dirt;
obj.Rock = vModel.DataObject.Rock;
obj.Ores = vModel.DataObject.Ores;
obj.OccursIn = vModel.DataObject.OccursIn;
if (string.IsNullOrWhiteSpace(message))
{
if (obj.Save(authedUser.GameAccount, authedUser.GetStaffRank(User)))
{
LoggingUtility.LogAdminCommandUsage("*WEB* - EditMinerals[" + obj.Id.ToString() + "]", authedUser.GameAccount.GlobalIdentityHandle);
message = "Edit Successful.";
}
else
{
message = "Error; Edit failed.";
}
}
return(RedirectToAction("Index", new { Message = message }));
}
private void Btn_AddMineral_Click(object sender, RoutedEventArgs e)
{
this.DataGrid.SelectedItem = null;
ClealComboBoxProperty();
ClealTextProperty();
IsAdd = true;
if (Viewflag == 1)
{
curMineral = new HomogeneousMineralInfo();
}
else if (Viewflag == 2)
{
curMineral = new HeterogeneousMineralInfo();
}
else
{
MessageBox.Show("请先确定添加的种类！");
}
}
private void showHomoOrHeteBtn_Click(object sender, RoutedEventArgs e)
{
ClealTextProperty();
UpdateCollections();
string tag = (sender as Button).Tag.ToString();
if (tag == "Hete")
{
InitDataGridByCollection(OrginHeteMinerals);
ShowHeteMineralInfoView();
curMineral = new HeterogeneousMineralInfo();
}
else if (tag == "H**o")
{
InitDataGridByCollection(OrginHomoMinerals);
ShowHomoMineralInfoView();
curMineral = new HomogeneousMineralInfo();
}
}
private void DataGrid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
{
IsAdd = false;
if (this.DataGrid.CurrentItem == null)
{
return;
}
//判断选择的是行数是属于非均质还是均质
if (this.DataGrid.CurrentItem.GetType().Name.Equals("HomogeneousMineralInfo"))
{
curMineral = this.DataGrid.CurrentItem as HomogeneousMineralInfo;
InitTextByEntity(curMineral);
}
else if (this.DataGrid.CurrentItem.GetType().Name.Equals("HeterogeneousMineralInfo"))
{
curMineral = this.DataGrid.CurrentItem as HeterogeneousMineralInfo;
InitTextByEntity(curMineral);
}
}
public ActionResult Add(AddEditMineralsViewModel vModel)
{
string message = string.Empty;
ApplicationUser authedUser = UserManager.FindById(User.Identity.GetUserId());
IMineral newObj = vModel.DataObject;
if (string.IsNullOrWhiteSpace(message))
{
if (newObj.Create(authedUser.GameAccount, authedUser.GetStaffRank(User)) == null)
{
message = "Error; Creation failed.";
}
else
{
LoggingUtility.LogAdminCommandUsage("*WEB* - AddMinerals[" + newObj.Id.ToString() + "]", authedUser.GameAccount.GlobalIdentityHandle);
message = "Creation Successful.";
}
}
return(RedirectToAction("Index", new { Message = message }));
}
/// <summary>
/// 向数据库添加一条记录
/// </summary>
/// <param name="dt">要添加的矿物所属表</param>
/// <param name="chineseName">矿物名称 用来检测是否重名</param>
/// <param name="mineral">要添加的矿物信息</param>
/// <param name="type">决定更新DataGrid的参数</param>
private void AddMineralToDB(DataTable dt, string chineseName, IMineral mineral, int type)
{
try
{
DataRow[] dataRow = dt.Select("ChineseName='" + chineseName + "'");
if (dataRow.Length > 0)
{
MessageBox.Show("已存在 ‘" + chineseName + "’ 矿物");
modifyNum++;
}
else
{
//开始增加矿物 并更新当前内存中的信息
AccessDB.Add(mineral);
//DataGrid.ItemsSource正在使用时无法操作
InitDataTable();
UpdateCollections();
if (type == 1)
{
InitDataGridByCollection(OrginHomoMinerals);
}
else if (type == 2)
{
InitDataGridByCollection(OrginHeteMinerals);
}
else
{
InitDataGridByCollection(OrginMinerals);
}
modifyNum = 0;
}
IsAdd = false;
}
catch (Exception)
{
}
}
/// <summary>
/// 通过对象增加数据库记录
/// </summary>
/// <param name="mineral"></param>
public static void Add(IMineral mineral)
{
if (mineral.mineralType == 1) //均质
{
HomogeneousMineralInfo homogeneousMineral = (HomogeneousMineralInfo)mineral;
string sql = String.Empty;
if (!string.IsNullOrEmpty(homogeneousMineral.Rr))
{
sql = String.Format(
"INSERT INTO HomogeneousMineral(ChineseName,EnglishName,ChemicalFormula,Syngony,NonUniformity,Reflectivity,Hardness,ReflectionColor,Rr,DRr,InternalReflection,Origin,IMK) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')",
homogeneousMineral.ChineseName, homogeneousMineral.EnglishName,
homogeneousMineral.ChemicalFormula, homogeneousMineral.Syngony,
homogeneousMineral.NonUniformity, homogeneousMineral.Reflectivity,
homogeneousMineral.Hardness, homogeneousMineral.ReflectionColor,
float.Parse(homogeneousMineral.Rr), homogeneousMineral.DRr,
homogeneousMineral.InternalReflection, homogeneousMineral.Origin,
homogeneousMineral.IMK);
}
else
{
sql = String.Format(
"INSERT INTO HomogeneousMineral(ChineseName,EnglishName,ChemicalFormula,Syngony,NonUniformity,Reflectivity,Hardness,ReflectionColor,DRr,InternalReflection,Origin,IMK) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')",
homogeneousMineral.ChineseName, homogeneousMineral.EnglishName,
homogeneousMineral.ChemicalFormula, homogeneousMineral.Syngony,
homogeneousMineral.NonUniformity, homogeneousMineral.Reflectivity,
homogeneousMineral.Hardness, homogeneousMineral.ReflectionColor, homogeneousMineral.DRr,
homogeneousMineral.InternalReflection, homogeneousMineral.Origin,
homogeneousMineral.IMK);
}
SqlHelper.ExecuteNonQuery(sql);
}
else if (mineral.mineralType == 2) //非均质
{
HeterogeneousMineralInfo heterogeneousMineral = (HeterogeneousMineralInfo)mineral;
string sql = String.Empty;
if (!string.IsNullOrEmpty(heterogeneousMineral.Ar))
{
sql = String.Format(
"INSERT INTO HeterogeneousMineral(ChineseName,EnglishName,ChemicalFormula,Syngony,NonUniformity,Reflectivity,Hardness,ReflectionColor,Bireflection,Ar,DAr,Rs,Ps,DRr,ReflectionDAR,InternalReflection,Origin,IMK) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}')",
heterogeneousMineral.ChineseName, heterogeneousMineral.EnglishName,
heterogeneousMineral.ChemicalFormula, heterogeneousMineral.Syngony,
heterogeneousMineral.NonUniformity, heterogeneousMineral.Reflectivity,
heterogeneousMineral.Hardness, heterogeneousMineral.ReflectionColor,
heterogeneousMineral.Bireflection, heterogeneousMineral.Ar, heterogeneousMineral.DAr,
heterogeneousMineral.Rs, heterogeneousMineral.Ps, heterogeneousMineral.DRr,
heterogeneousMineral.ReflectionDAR, heterogeneousMineral.InternalReflection,
heterogeneousMineral.Origin, heterogeneousMineral.IMK);
}
else
{
sql = String.Format(
"INSERT INTO HeterogeneousMineral(ChineseName,EnglishName,ChemicalFormula,Syngony,NonUniformity,Reflectivity,Hardness,ReflectionColor,Bireflection,DAr,Rs,Ps,DRr,ReflectionDAR,InternalReflection,Origin,IMK) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}')",
heterogeneousMineral.ChineseName, heterogeneousMineral.EnglishName,
heterogeneousMineral.ChemicalFormula, heterogeneousMineral.Syngony,
heterogeneousMineral.NonUniformity, heterogeneousMineral.Reflectivity,
heterogeneousMineral.Hardness, heterogeneousMineral.ReflectionColor,
heterogeneousMineral.Bireflection, heterogeneousMineral.DAr,
heterogeneousMineral.Rs, heterogeneousMineral.Ps, heterogeneousMineral.DRr,
heterogeneousMineral.ReflectionDAR, heterogeneousMineral.InternalReflection,
heterogeneousMineral.Origin, heterogeneousMineral.IMK);
}
SqlHelper.ExecuteNonQuery(sql);
}
}
/// <summary>
/// 更新数据库
/// </summary>
/// <param name="mineral"></param>
public static void Update(IMineral mineral)
{
if (mineral.mineralType == 1)
{
HomogeneousMineralInfo homogeneousMineral = (HomogeneousMineralInfo)mineral;
string sql = String.Empty;
if (!string.IsNullOrEmpty(homogeneousMineral.Rr))
{
sql = String.Format(
"UPDATE HomogeneousMineral SET ChineseName='{0}',EnglishName='{1}',ChemicalFormula='{2}',Syngony='{3}',NonUniformity='{4}',Reflectivity='{5}',Hardness='{6}',ReflectionColor='{7}',Rr='{8}',DRr='{9}',InternalReflection='{10}',Origin='{11}',IMK='{12}' WHERE ID={13}",
homogeneousMineral.ChineseName, homogeneousMineral.EnglishName,
homogeneousMineral.ChemicalFormula, homogeneousMineral.Syngony,
homogeneousMineral.NonUniformity, homogeneousMineral.Reflectivity,
homogeneousMineral.Hardness, homogeneousMineral.ReflectionColor, homogeneousMineral.Rr,
homogeneousMineral.DRr, homogeneousMineral.InternalReflection,
homogeneousMineral.Origin, homogeneousMineral.IMK, homogeneousMineral.ID);
}
else
{
sql = String.Format(
"UPDATE HomogeneousMineral SET ChineseName='{0}',EnglishName='{1}',ChemicalFormula='{2}',Syngony='{3}',NonUniformity='{4}',Reflectivity='{5}',Hardness='{6}',ReflectionColor='{7}',DRr='{8}',InternalReflection='{9}',Origin='{10}',IMK='{11}' WHERE ID={12}",
homogeneousMineral.ChineseName, homogeneousMineral.EnglishName,
homogeneousMineral.ChemicalFormula, homogeneousMineral.Syngony,
homogeneousMineral.NonUniformity, homogeneousMineral.Reflectivity,
homogeneousMineral.Hardness, homogeneousMineral.ReflectionColor,
homogeneousMineral.DRr, homogeneousMineral.InternalReflection,
homogeneousMineral.Origin, homogeneousMineral.IMK, homogeneousMineral.ID);
}
SqlHelper.ExecuteNonQuery(sql);
}
else if (mineral.mineralType == 2)
{
HeterogeneousMineralInfo heterogeneousMineral = (HeterogeneousMineralInfo)mineral;
string sql = String.Empty;
if (!string.IsNullOrEmpty(heterogeneousMineral.Ar))
{
sql = String.Format(
"UPDATE HeterogeneousMineral SET ChineseName='{0}',EnglishName='{1}',ChemicalFormula='{2}',Syngony='{3}',NonUniformity='{4}',Reflectivity='{5}',Hardness='{6}',ReflectionColor='{7}',Bireflection='{8}',Ar='{9}',DAr='{10}',Rs='{11}',Ps='{12}',DRr='{13}',ReflectionDAR='{14}',InternalReflection='{15}',Origin='{16}',IMK='{17}' WHERE ID={18}",
heterogeneousMineral.ChineseName, heterogeneousMineral.EnglishName,
heterogeneousMineral.ChemicalFormula, heterogeneousMineral.Syngony,
heterogeneousMineral.NonUniformity, heterogeneousMineral.Reflectivity,
heterogeneousMineral.Hardness, heterogeneousMineral.ReflectionColor,
heterogeneousMineral.Bireflection, heterogeneousMineral.Ar, heterogeneousMineral.DAr,
heterogeneousMineral.Rs, heterogeneousMineral.Ps, heterogeneousMineral.DRr,
heterogeneousMineral.ReflectionDAR, heterogeneousMineral.InternalReflection,
heterogeneousMineral.Origin, heterogeneousMineral.IMK, heterogeneousMineral.ID);
}
else
{
sql = String.Format(
"UPDATE HeterogeneousMineral SET ChineseName='{0}',EnglishName='{1}',ChemicalFormula='{2}',Syngony='{3}',NonUniformity='{4}',Reflectivity='{5}',Hardness='{6}',ReflectionColor='{7}',Bireflection='{8}',DAr='{9}',Rs='{10}',Ps='{11}',DRr='{12}',ReflectionDAR='{13}',InternalReflection='{14}',Origin='{15}',IMK='{16}' WHERE ID={17}",
heterogeneousMineral.ChineseName, heterogeneousMineral.EnglishName,
heterogeneousMineral.ChemicalFormula, heterogeneousMineral.Syngony,
heterogeneousMineral.NonUniformity, heterogeneousMineral.Reflectivity,
heterogeneousMineral.Hardness, heterogeneousMineral.ReflectionColor,
heterogeneousMineral.Bireflection, heterogeneousMineral.DAr,
heterogeneousMineral.Rs, heterogeneousMineral.Ps, heterogeneousMineral.DRr,
heterogeneousMineral.ReflectionDAR, heterogeneousMineral.InternalReflection,
heterogeneousMineral.Origin, heterogeneousMineral.IMK, heterogeneousMineral.ID);
}
SqlHelper.ExecuteNonQuery(sql);
}
}
