public int SaveEncryption(signtype mm)
{
var prams = new List <DbParameter>
{
Database.MakeInParam("keyName", mm.keyName),
Database.MakeInParam("signArray", mm.signArray),
Database.MakeInParam("splicetype", mm.splicetype),
Database.MakeInParam("joiner1", mm.joiner1),
Database.MakeInParam("joiner2", mm.joiner2),
Database.MakeInParam("type", mm.type),
Database.MakeInParam("updown", mm.updown),
Database.MakeInParam("mapPos", mm.mapPos),
Database.MakeInParam("cyphertext", mm.cyphertext),
Database.MakeInParam("cypType", mm.cypType),
Database.MakeInParam("name", mm.name)
};
string sqlQuery;
if (mm.id == 0)
{
sqlQuery = @"INSERT INTO [dbo].[signtype]( [keyName], [signArray], [splicetype], [joiner1], [joiner2], [type], [updown], [mapPos], [cyphertext], [cypType], [name])
VALUES (@keyName,@signArray,@splicetype,@joiner1,@joiner2,@type,@updown,@mapPos,@cyphertext,@cypType,@name)";
}
else
{
prams.Add(Database.MakeInParam("id", mm.id));
sqlQuery = @"UPDATE [dbo].[signtype] SET keyName=@keyName,signArray=@signArray,splicetype=@splicetype,joiner1=@joiner1,joiner2=@joiner2,type=@type,
updown=@updown,mapPos=@mapPos,cyphertext=@cyphertext,cypType=@cypType,name=@name WHERE id=@id";
}
return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery, prams.ToArray()));
}
private void BindData()
{
if (IntParam > 0)
{
signtype mm = FacadeManage.aideTreasureFacade.GetSignById(IntParam);
TxtName.Text = mm.name;
TextBox2.Text = mm.keyName;
SignArray.Text = mm.signArray;
TextBox3.Text = mm.splicetype.ToString();
TextBox1.Text = mm.joiner1;
TextBox4.Text = mm.joiner2;
TextBox5.Text = mm.type.ToString();
TextBox6.Text = mm.updown.ToString();
TextBox7.Text = mm.mapPos;
TextBox8.Text = mm.cyphertext;
TextBox9.Text = mm.cypType.ToString();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
signtype mm = new signtype();
if (IntParam > 0)
{
if (!AuthUserOperationPermission(Permission.Edit))
{
return;
}
mm = FacadeManage.aideTreasureFacade.GetSignById(IntParam);
}
else
{
if (!AuthUserOperationPermission(Permission.Add))
{
return;
}
}
mm.keyName = TextBox2.Text;
mm.name = TxtName.Text;
mm.signArray = SignArray.Text;
mm.splicetype = Convert.ToByte(TextBox3.Text);
mm.joiner1 = TextBox1.Text;
mm.joiner2 = TextBox4.Text;
mm.type = Convert.ToByte(TextBox5.Text);
mm.updown = Convert.ToByte(TextBox6.Text);
mm.mapPos = TextBox7.Text;
mm.cyphertext = TextBox8.Text;
mm.cypType = Convert.ToByte(TextBox9.Text);
int result = FacadeManage.aideTreasureFacade.SaveEncryption(mm);
if (result > 0)
{
ShowInfo("配置信息操作成功", "EncryptionList.aspx", 1200);
}
else
{
ShowError("配置信息操作失败");
}
}
public int SaveEncryption(signtype mm)
{
return(aideTreasureData.SaveEncryption(mm));
}
