public string DeleteContract(string Id)
{
string returnStr = "删除成功";
StringBuilder sbSQL = new StringBuilder();
sbSQL.Append(" exec ZCGF_DeleteMaterial_TclassifyAndList'"+ Id+"' select @@ROWCOUNT as a");//表1
DataTable dtTemp = XCode.DataAccessLayer.DAL.QuerySQL(sbSQL.ToString()); //执行
foreach (DataRow item in dtTemp.Rows)
{
if((int)(item["a"])==1)
{
returnStr = "删除成功";
}
else
{
returnStr = "删除失败!";
}
}
return returnStr;
}
2.JavaScript代码:
function DeleteContract() {
Power.ui.confirm("您确定要删除该节点,删除该节点,则材料管理下该节点的数据将全部被删除!", "提示信息",
function (action) {
if (!action) return;
if (action) {
var Id = mini.get("Material_Tclassify").getSelected().Id;
var exec = {}; //对象
exec.KeyWord = "Material_Tclassify"; //bo的KeyWord
exec.MethodName = "DeleteContract"; //方法名称
//如果是数据集的话,要加上 exec.KeyWordType="ViewEntity";
exec.MethodParams = {}; //方法参数
var params = exec.MethodParams;
params.Id = Id;
var txt = mini.encode(exec); //对象转换成字符串
$.ajax({
url: "/API/Exec",
type: "POST",
data: { jsonData: txt }, //对象字符串传递给 jsonData变量
cache: false,
success: function (text) {
var tmp = mini.decode(text);
var returnStr = tmp.data.value;
Power.ui.alert(returnStr);
mini.get("Material_Tclassify").reload()
}
});
}
else {
Power.ui.alert("取消删除");
}
}
);
}